APPS.OPI_DBI_INV_VALUE_OPM_INCR_PKG dependencies on IC_WHSE_MST

Line 230: IC_WHSE_MST WHSE

226: AND led.gl_doc_date >= :3
227: AND DOC_TYPE = ''RVAL''
228: GROUP BY doc_id, line_id, TRUNC(gl_doc_date)
229: ) led,
230: IC_WHSE_MST WHSE
231: WHERE
232: led.doc_id = whse.mtl_organization_id
233: GROUP BY
234: whse.whse_code,

Line 402: ic_whse_mst whse_mst,

398: GROUP BY doc_type, doc_id, line_id, whse_code, item_id,
399: trans_um, gl_posted_ind, 1
400: ) pnd,
401: gl_subr_led led,
402: ic_whse_mst whse_mst,
403: mtl_system_items_b msi,
404: ic_item_mst_b ic_item,
405: ic_xfer_mst xfer
406: WHERE pnd.doc_id = led.doc_id

Line 666: ic_whse_mst w

662: AND :2
663: AND trunc(subr.gl_trans_date) >= :3
664: AND acct_ttl_type = 1590
665: ) led,
666: ic_whse_mst w
667: WHERE ic_tran.doc_type = led.doc_type
668: AND ic_tran.line_id = led.line_id
669: AND ic_tran.line_id = oola.line_id -- get line id details
670: AND oola.source_document_type_id = 10 --ensure this is internal

Line 748: ic_whse_mst w

744: AND :5
745: AND trunc(subr.gl_trans_date) >= :6
746: AND acct_ttl_type = 1590 -- internal order account
747: ) led,
748: ic_whse_mst w
749: WHERE ic_tran.doc_type = led.doc_type
750: AND ic_tran.line_id = led.line_id
751: AND rcv.transaction_id = led.line_id
752: AND req.requisition_line_id = rcv.requisition_line_id

Line 953: ic_whse_mst whse,

949: OR SUM(intransit_value_b) <> 0
950: OR SUM(wip_value_b) <> 0
951: ) stg,
952: ic_item_mst_b iim,
953: ic_whse_mst whse,
954: mtl_system_items_b msi
955: WHERE
956: iim.item_id = stg.item_id
957: AND whse.whse_code = stg.whse_code