[Home] [Help]
686: INTO x_blanket_number,
687: x_blanket_version_number,
688: x_blanket_line_number
689: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
690: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
691: WHERE BH.HEADER_ID = BL.HEADER_ID
692: AND BL.CUST_PO_NUMBER = p_cust_po_number
693: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
694: AND BHE.ON_HOLD_FLAG = 'N'
713: INTO x_blanket_number,
714: x_blanket_version_number,
715: x_blanket_line_number
716: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
717: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
718: WHERE BH.HEADER_ID = BL.HEADER_ID
719: AND BH.ORDER_NUMBER = l_blanket_number
720: -- Do not match customer if blanket number is supplied
721: -- With 11.5.10, customer on blanket could be
761: INTO x_blanket_number,
762: x_blanket_version_number,
763: x_blanket_line_number
764: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
765: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
766: WHERE BH.HEADER_ID = BL.HEADER_ID
767: AND BL.CUST_PO_NUMBER = p_cust_po_number
768: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
769: AND BHE.ON_HOLD_FLAG = 'N'
782: INTO x_blanket_number,
783: x_blanket_version_number,
784: x_blanket_line_number
785: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
786: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
787: WHERE BH.HEADER_ID = BL.HEADER_ID
788: AND BH.ORDER_NUMBER = l_blanket_number
789: -- Do not match customer if blanket number is supplied
790: -- With 11.5.10, customer on blanket could be
824: INTO x_blanket_number,
825: x_blanket_version_number,
826: x_blanket_line_number
827: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC,
828: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
829: WHERE BH.HEADER_ID = BL.HEADER_ID
830: AND BL.CUST_PO_NUMBER = p_cust_po_number
831: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
832: AND BHE.ON_HOLD_FLAG = 'N'
847: INTO x_blanket_number,
848: x_blanket_version_number,
849: x_blanket_line_number
850: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL, MTL_ITEM_CATEGORIES IC
851: ,OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
852: WHERE BH.HEADER_ID = BL.HEADER_ID
853: AND BH.ORDER_NUMBER = l_blanket_number
854: -- Do not match customer if blanket number is supplied
855: -- With 11.5.10, customer on blanket could be
890: INTO x_blanket_number,
891: x_blanket_version_number,
892: x_blanket_line_number
893: FROM OE_BLANKET_HEADERS BH, OE_BLANKET_LINES_ALL BL,
894: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
895: WHERE BH.HEADER_ID = BL.HEADER_ID
896: AND BL.CUST_PO_NUMBER = p_cust_po_number
897: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
898: AND BHE.ON_HOLD_FLAG = 'N'
910: INTO x_blanket_number,
911: x_blanket_version_number,
912: x_blanket_line_number
913: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_LINES BL,
914: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
915: WHERE BH.HEADER_ID = BL.HEADER_ID
916: AND BH.ORDER_NUMBER = l_blanket_number
917: -- Do not match customer if blanket number is supplied
918: -- With 11.5.10, customer on blanket could be
1242: x_blanket_version_number
1243:
1244: FROM OE_BLANKET_LINES BL,
1245: OE_BLANKET_HEADERS_ALL BH,
1246: OE_BLANKET_HEADERS_EXT BHE,
1247: OE_BLANKET_LINES_EXT BLE
1248: WHERE BH.ORDER_NUMBER = p_blanket_number
1249: AND BL.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID
1250: AND BH.HEADER_ID = BL.HEADER_ID
1268: x_blanket_version_number
1269:
1270: FROM OE_BLANKET_LINES BL,
1271: OE_BLANKET_HEADERS_ALL BH,
1272: OE_BLANKET_HEADERS_EXT BHE,
1273: OE_BLANKET_LINES_EXT BLE
1274: WHERE BH.ORDER_NUMBER = p_blanket_number
1275: AND BH.HEADER_ID = BL.HEADER_ID
1276: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER