DBA Data[Home] [Help]

APPS.PMI_SALES_PKG dependencies on GL_PLCY_MST

Line 223: GL_PLCY_MST pol

219: OP_ORDR_HDR orderhdr,
220: OP_ORDR_DTL orderdetail,
221: IC_ITEM_MST itemmst,
222: SY_ORGN_MST org,
223: GL_PLCY_MST pol
224: WHERE orderhdr.order_id = orderdetail.order_id
225: AND orderdetail.item_id = itemmst.item_id
226: AND trunc(orderdetail.ACTUAL_SHIPDATE)
227: between p_prd_start_date and p_prd_end_date

Line 309: GL_PLCY_MST pol

305: OP_ORDR_HDR orderhdr,
306: OP_ORDR_DTL orderdetail,
307: IC_ITEM_MST itemmst,
308: SY_ORGN_MST org,
309: GL_PLCY_MST pol
310: WHERE orderhdr.order_id = orderdetail.order_id
311: AND orderdetail.item_id = itemmst.item_id
312: AND trunc(orderdetail.ACTUAL_SHIPDATE)
313: between p_prd_start_date and p_prd_end_date