DBA Data[Home] [Help]

APPS.OPI_DBI_PRE_R12_COGS_PKG dependencies on IC_WHSE_MST

Line 117: ic_whse_mst whse

113: GROUP BY doc_type, line_id, line_id, orgn_code, whse_code) tran,
114: oe_order_lines_all lines,
115: hz_cust_accounts cust_acct,
116: mtl_system_items_b msi,
117: ic_whse_mst whse
118: WHERE led.doc_type in ( 'OMSO', 'PORC' )
119: AND led.acct_ttl_type = 5200
120: AND lines.line_id = tran.oe_order_line_id
121: AND lines.sold_to_org_id = cust_acct.cust_account_id(+)