APPS.QP_BULK_VALIDATE dependencies on QP_LOOKUPS

Line 4269: FROM QP_LOOKUPS

4265: QP_BULK_MSG.Add(l_msg_rec);
4266: ElSE
4267: SELECT lookup_code
4268: INTO l_comparison_operator_code
4269: FROM QP_LOOKUPS
4270: WHERE LOOKUP_TYPE = 'COMPARISON_OPERATOR'
4271: AND LOOKUP_CODE = UPPER(p_Pricing_Attr_rec.comparison_operator_code(I));
4272:
4273: If SQL%NOTFOUND

Line 5239: FROM qp_lookups

5235: AND qpih.process_status_flag ='P' --is null
5236: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5237: AND qpih.list_type_code IS NOT NULL
5238: AND NOT EXISTS (SELECT lookup_code
5239: FROM qp_lookups
5240: WHERE lookup_type = 'LIST_TYPE_CODE'
5241: AND lookup_code = qpih.list_type_code);
5242:
5243: -- 4.Ship Method(Freight Carrier)

Line 5601: FROM qp_lookups

5597: AND qpih.process_status_flag ='P' --is null
5598: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5599: AND qpih.pte_code IS NOT NULL
5600: AND NOT EXISTS (SELECT lookup_code
5601: FROM qp_lookups
5602: WHERE lookup_type = 'QP_PTE_TYPE'
5603: AND lookup_code = qpih.pte_code);
5604:
5605: -- 11. Source System Code

Line 5628: FROM qp_lookups

5624: AND qpih.process_status_flag ='P' --is null
5625: AND qpih.interface_action_code IN ('INSERT', 'UPDATE')
5626: AND qpih.source_system_code IS NOT NULL
5627: AND NOT EXISTS (SELECT lookup_code
5628: FROM qp_lookups
5629: WHERE lookup_type = 'SOURCE_SYSTEM'
5630: AND lookup_code = qpih.source_system_code);
5631:
5632: -- Bug 5208365 RAVI

Line 5782: FROM qp_lookups

5778: AND qpiq.process_status_flag ='P' --is null
5779: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5780: AND qpiq.comparison_operator_code is NOT NULL
5781: AND NOT EXISTS ( SELECT lookup_code
5782: FROM qp_lookups
5783: WHERE lookup_type = 'COMPARISON_OPERATOR'
5784: AND lookup_code = qpiq.comparison_operator_code);
5785:
5786: --2. Orig sys header ref

Line 6042: FROM qp_lookups

6038: AND qpil.process_status_flag ='P' --is null
6039: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6040: AND qpil.list_line_type_code is NOT NULL
6041: AND NOT EXISTS ( SELECT lookup_code
6042: FROM qp_lookups
6043: WHERE lookup_type= 'LIST_LINE_TYPE_CODE'
6044: AND lookup_code= qpil.list_line_type_code
6045: AND qpil.list_line_type_code IN ('PLL', 'PBH') );
6046:

Line 6069: FROM qp_lookups

6065: AND qpil.process_status_flag ='P' --is null
6066: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6067: AND qpil.arithmetic_operator is NOT NULL
6068: AND NOT EXISTS ( SELECT meaning
6069: FROM qp_lookups
6070: WHERE lookup_type= 'ARITHMETIC_OPERATOR'
6071: AND lookup_code= qpil.arithmetic_operator );
6072:
6073: --3. PRICE BREAK TYPE CODE

Line 6095: FROM qp_lookups

6091: AND qpil.process_status_flag ='P' --is null
6092: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6093: AND qpil.price_break_type_code is NOT NULL
6094: AND NOT EXISTS ( SELECT meaning
6095: FROM qp_lookups
6096: WHERE lookup_type= 'PRICE_BREAK_TYPE_CODE'
6097: AND lookup_code= qpil.price_break_type_code);
6098:
6099: --4. UOM