[Home] [Help]
171: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID,
172: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS) TURNS_COGS_FLAG,
173: OPM_SOURCE SOURCE
174: from oe_order_lines_all lines,
175: hz_cust_accounts cust_acct,
176: ic_whse_mst whse,
177: mtl_system_items_b msi,
178: (select /*+ leading(tst) index(tran,IC_TRAN_PNDI2) use_nl(tran) */ rcv.oe_order_line_id oe_order_line_id,
179: tran.line_id,
265: ,max(COGS_DATE)
266: ,SOURCE
267: ,TURNS_COGS_FLAG
268: from
269: ( select /*+ index(cust_acct, HZ_CUST_ACCOUNTS_U1) use_nl(cust_acct) */
270: lines.inventory_item_id INVENTORY_ITEM_ID,
271: whse.mtl_organization_id ORGANIZATION_ID,
272: tran.oe_order_line_id ORDER_LINE_ID,
273: msi.primary_uom_code TOP_MODEL_ITEM_UOM,
276: nvl(cust_acct.party_id, -1) SOLD_TO_ORG_ID,
277: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS) TURNS_COGS_FLAG,
278: OPM_SOURCE SOURCE
279: from oe_order_lines_all lines,
280: hz_cust_accounts cust_acct,
281: ic_whse_mst whse,
282: mtl_system_items_b msi,
283: (select
284: rcv.oe_order_line_id oe_order_line_id,
436: Decode(lines.source_type_code, 'EXTERNAL', DO_NOT_INCLUDE_FOR_TURNS,INCLUDE_FOR_TURNS ) TURNS_COGS_FLAG ,
437: OPM_SOURCE SOURCE
438: from gl_subr_tst tst,
439: oe_order_lines_all lines,
440: hz_cust_accounts cust_acct,
441: ic_whse_mst whse,
442: mtl_system_items_b msi,
443: (
444: select /*+ full(tran) full(rcv) use_hash(tran) parallel(tran) parallel(rcv) */
560: and completed_ind = 1
561: and gl_posted_ind = 1
562: group by doc_type, line_id, line_id, orgn_code, whse_code) tran,
563: oe_order_lines_all lines,
564: hz_cust_accounts cust_acct,
565: mtl_system_items_b msi,
566: ic_whse_mst whse
567: where tst.doc_type in ( 'OMSO', 'PORC' )
568: and tst.acct_ttl_type = 5200