Home » Applications » Oracle Fusion Apps & E-Business Suite » GME_INVENTORY_TXNS_GTMP - global temporary table do módulo OPM
GME_INVENTORY_TXNS_GTMP - global temporary table do módulo OPM [message #525481] Mon, 03 October 2011 07:57 Go to next message
suelana
Messages: 1
Registered: October 2011
Location: Medianeira, PR
Junior Member

Prezados,

Preciso saber como é, ou melhor, qual a query que add linhas nesta tabela temporária.

Procurei na base (Oracle Database 10g EE Release 10.2.0.3.0) e não consegui identificar onde/como é carregado .

Preciso saber como é preenchida a coluna ACTION_CODE.

No EBS (11i) - módulo OPM, tela "Ordem de Produção", pesquiso uma OP e clico em Detalhes do Material -> "Alocações de Linha" (bloco Ingredientes), é aberta a janela com os lotes das alocações (tab temp GME_INVENTORY_TXNS_GTMP).

De q tabelas vem as informações q preenchem esta tabela temporária??

Agradeço desde já,
Suelana
Re: GME_INVENTORY_TXNS_GTMP - global temporary table do módulo OPM [message #525500 is a reply to message #525481] Mon, 03 October 2011 10:16 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Welcome to the forum.
Please read OraFAQ Forum Guide, even "Detailed OraFAQ Forum Guide" section especially for non-English forum.
Also read Oracle Apps Forum Guide.

In this current thread, please post it in English to get quicker response.

I tried Google Translator.Quote:
Dear,

I need to know how, or rather, what is the query to add rows in this temporary table.

I looked at the base (Oracle Database 10g Release 10.2.0.3.0 EE) and I could not tell where / how is loaded.

Need to know how the column is filled ACTION_CODE.

In EBS (11i) - OPM module, the screen "Production Order", researching an OP and click on Details Material -> "Line Allocations" (block ingredients), the window is open with lots of allocations (temp tab GME_INVENTORY_TXNS_GTMP ).

Q q tables fill the information comes from this temporary table?

Thanks in advance,
Suelana
Check Help -> Diagnostics -> Record History.
(Or) Otherwise check "About Oracle Applications" and the form name.
You may check the form code from $AU_TOP/forms/US.

By,
Vamsi

[Updated on: Mon, 03 October 2011 10:21]

Report message to a moderator

Previous Topic: Query change from 11i to R12 (2 threads merged by bb)
Next Topic: India Localization FIFO Costing
Goto Forum:
  


Current Time: Tue Sep 30 19:45:41 CDT 2014

Total time taken to generate the page: 0.23203 seconds