APPS.MRP_EXPL_STD_MANDATORY dependencies on OE_ORDER_LINES_ALL

Line 95: FROM oe_order_lines_all oel

91: p_atp_table.Vendor_Site_Id ,
92: p_atp_table.Insert_Flag ,
93: p_atp_table.Error_Code ,
94: p_atp_table.Message
95: FROM oe_order_lines_all oel
96: WHERE oel.line_id = pLineId;
97:
98:
99: /* Passing NULL for source_organization_id and inventory_item_id so that CTO

Line 404: FROM oe_order_lines_all oel

400: p_get_oe_record.Requested_Ship_Date ,
401: p_get_oe_record.Demand_Class ,
402: p_get_oe_record.mfg_lead_time,
403: p_get_oe_record.ITEM_TYPE_CODE
404: FROM oe_order_lines_all oel
405: WHERE oel.ato_line_id = pATOLineId
406: AND oel.line_id <> pLineId;
407:
408: IF p_get_oe_record.inventory_item_id.EXISTS(1) THEN

Line 574: FROM oe_order_lines_all oel

570: /* If the ATO item is shipped, get 1 into lv_ato_item_shipped,
571: else get the value of 0 */
572: SELECT decode(NVL(oel.shipped_quantity,0),0,0,1)
573: INTO lv_ato_item_shipped
574: FROM oe_order_lines_all oel
575: WHERE oel.line_id = pLineId;
576:
577: /* If the ATO item is shipped then get the SMC's qty = 0 */
578: IF (lv_ato_item_shipped = 1) THEN