OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » GME_INVENTORY_TXNS_GTMP

Home » Applications » Oracle Fusion Apps & E-Business Suite » GME_INVENTORY_TXNS_GTMP - global temporary table do módulo OPM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GME_INVENTORY_TXNS_GTMP - global temporary table do módulo OPM [message #525481]

Mon, 03 October 2011 07:57

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

Report message to a moderator

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:06:33 CDT 2024