[Home] [Help]
684: INTO x_blanket_number,
685: x_blanket_version_number,
686: x_blanket_line_number
687: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
688: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
689: WHERE BH.HEADER_ID = BL.HEADER_ID
690: AND BL.CUST_PO_NUMBER = p_cust_po_number
691: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
692: AND BHE.ON_HOLD_FLAG = 'N'
711: INTO x_blanket_number,
712: x_blanket_version_number,
713: x_blanket_line_number
714: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
715: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
716: WHERE BH.HEADER_ID = BL.HEADER_ID
717: AND BH.ORDER_NUMBER = l_blanket_number
718: -- Do not match customer if blanket number is supplied
719: -- With 11.5.10, customer on blanket could be
759: INTO x_blanket_number,
760: x_blanket_version_number,
761: x_blanket_line_number
762: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
763: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
764: WHERE BH.HEADER_ID = BL.HEADER_ID
765: AND BL.CUST_PO_NUMBER = p_cust_po_number
766: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
767: AND BHE.ON_HOLD_FLAG = 'N'
780: INTO x_blanket_number,
781: x_blanket_version_number,
782: x_blanket_line_number
783: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
784: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
785: WHERE BH.HEADER_ID = BL.HEADER_ID
786: AND BH.ORDER_NUMBER = l_blanket_number
787: -- Do not match customer if blanket number is supplied
788: -- With 11.5.10, customer on blanket could be
822: INTO x_blanket_number,
823: x_blanket_version_number,
824: x_blanket_line_number
825: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC,
826: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
827: WHERE BH.HEADER_ID = BL.HEADER_ID
828: AND BL.CUST_PO_NUMBER = p_cust_po_number
829: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
830: AND BHE.ON_HOLD_FLAG = 'N'
845: INTO x_blanket_number,
846: x_blanket_version_number,
847: x_blanket_line_number
848: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC
849: ,OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
850: WHERE BH.HEADER_ID = BL.HEADER_ID
851: AND BH.ORDER_NUMBER = l_blanket_number
852: -- Do not match customer if blanket number is supplied
853: -- With 11.5.10, customer on blanket could be
888: INTO x_blanket_number,
889: x_blanket_version_number,
890: x_blanket_line_number
891: FROM OE_BLANKET_HEADERS BH, OE_BLANKET_LINES_ALL BL,
892: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
893: WHERE BH.HEADER_ID = BL.HEADER_ID
894: AND BL.CUST_PO_NUMBER = p_cust_po_number
895: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
896: AND BHE.ON_HOLD_FLAG = 'N'
908: INTO x_blanket_number,
909: x_blanket_version_number,
910: x_blanket_line_number
911: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
912: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
913: WHERE BH.HEADER_ID = BL.HEADER_ID
914: AND BH.ORDER_NUMBER = l_blanket_number
915: -- Do not match customer if blanket number is supplied
916: -- With 11.5.10, customer on blanket could be
1180: x_blanket_version_number
1181:
1182: FROM OE_BLANKET_LINES BL,
1183: OE_BLANKET_HEADERS_ALL BH,
1184: OE_BLANKET_HEADERS_EXT BHE,
1185: OE_BLANKET_LINES_EXT BLE
1186: WHERE BH.ORDER_NUMBER = p_blanket_number
1187: AND BL.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
1188: AND BH.HEADER_ID = BL.HEADER_ID
1206: x_blanket_version_number
1207:
1208: FROM OE_BLANKET_LINES BL,
1209: OE_BLANKET_HEADERS_ALL BH,
1210: OE_BLANKET_HEADERS_EXT BHE,
1211: OE_BLANKET_LINES_EXT BLE
1212: WHERE BH.ORDER_NUMBER = p_blanket_number
1213: AND BH.HEADER_ID = BL.HEADER_ID
1214: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER