APPS.QP_BULK_VALIDATE dependencies on QP_LOOKUPS

Line 4157: FROM QP_LOOKUPS

4153: QP_BULK_MSG.Add(l_msg_rec);
4154: ElSE
4155: SELECT lookup_code
4156: INTO l_comparison_operator_code
4157: FROM QP_LOOKUPS
4158: WHERE LOOKUP_TYPE = 'COMPARISON_OPERATOR'
4159: AND LOOKUP_CODE = UPPER(p_Pricing_Attr_rec.comparison_operator_code(I));
4160:
4161: If SQL%NOTFOUND

Line 5227: FROM qp_lookups

5223: AND qpih.process_status_flag ='P' --is null
5224: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5225: AND qpih.list_type_code IS NOT NULL
5226: AND NOT EXISTS (SELECT lookup_code
5227: FROM qp_lookups
5228: WHERE lookup_type = 'LIST_TYPE_CODE'
5229: AND lookup_code = qpih.list_type_code);
5230:
5231: -- 4.Ship Method(Freight Carrier)

Line 5589: FROM qp_lookups

5585: AND qpih.process_status_flag ='P' --is null
5586: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5587: AND qpih.pte_code IS NOT NULL
5588: AND NOT EXISTS (SELECT lookup_code
5589: FROM qp_lookups
5590: WHERE lookup_type = 'QP_PTE_TYPE'
5591: AND lookup_code = qpih.pte_code);
5592:
5593: -- 11. Source System Code

Line 5616: FROM qp_lookups

5612: AND qpih.process_status_flag ='P' --is null
5613: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5614: AND qpih.source_system_code IS NOT NULL
5615: AND NOT EXISTS (SELECT lookup_code
5616: FROM qp_lookups
5617: WHERE lookup_type = 'SOURCE_SYSTEM'
5618: AND lookup_code = qpih.source_system_code);
5619:
5620: -- Bug 5208365 RAVI

Line 5770: FROM qp_lookups

5766: AND qpiq.process_status_flag ='P' --is null
5767: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5768: AND qpiq.comparison_operator_code is NOT NULL
5769: AND NOT EXISTS ( SELECT lookup_code
5770: FROM qp_lookups
5771: WHERE lookup_type = 'COMPARISON_OPERATOR'
5772: AND lookup_code = qpiq.comparison_operator_code);
5773:
5774: --2. Orig sys header ref

Line 6030: FROM qp_lookups

6026: AND qpil.process_status_flag ='P' --is null
6027: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6028: AND qpil.list_line_type_code is NOT NULL
6029: AND NOT EXISTS ( SELECT lookup_code
6030: FROM qp_lookups
6031: WHERE lookup_type= 'LIST_LINE_TYPE_CODE'
6032: AND lookup_code= qpil.list_line_type_code
6033: AND qpil.list_line_type_code IN ('PLL', 'PBH') );
6034:

Line 6057: FROM qp_lookups

6053: AND qpil.process_status_flag ='P' --is null
6054: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6055: AND qpil.arithmetic_operator is NOT NULL
6056: AND NOT EXISTS ( SELECT meaning
6057: FROM qp_lookups
6058: WHERE lookup_type= 'ARITHMETIC_OPERATOR'
6059: AND lookup_code= qpil.arithmetic_operator );
6060:
6061: --3. PRICE BREAK TYPE CODE

Line 6083: FROM qp_lookups

6079: AND qpil.process_status_flag ='P' --is null
6080: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6081: AND qpil.price_break_type_code is NOT NULL
6082: AND NOT EXISTS ( SELECT meaning
6083: FROM qp_lookups
6084: WHERE lookup_type= 'PRICE_BREAK_TYPE_CODE'
6085: AND lookup_code= qpil.price_break_type_code);
6086:
6087: --4. UOM