APPS.QP_BULK_VALIDATE dependencies on QP_PRICE_FORMULAS_VL

Line 6283: FROM qp_price_formulas_vl

6279: AND qpil.price_by_formula_id is NOT NULL
6280: AND qpil.price_by_formula is NOT NULL
6281: AND qpil.price_by_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6282: AND NOT EXISTS ( SELECT name
6283: FROM qp_price_formulas_vl
6284: WHERE price_formula_id = qpil.price_by_formula_id
6285: AND name = qpil.price_by_formula);
6286:
6287: INSERT INTO QP_INTERFACE_ERRORS

Line 6305: FROM qp_price_formulas_vl

6301: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6302: AND qpil.price_by_formula_id is NOT NULL
6303: AND qpil.price_by_formula is NULL
6304: AND NOT EXISTS ( SELECT name
6305: FROM qp_price_formulas_vl
6306: WHERE price_formula_id = qpil.price_by_formula_id);
6307:
6308: INSERT INTO QP_INTERFACE_ERRORS
6309: (error_id,last_update_date, last_updated_by, creation_date,

Line 6327: FROM qp_price_formulas_vl

6323: AND qpil.price_by_formula_id is NULL
6324: AND qpil.price_by_formula is NOT NULL
6325: AND qpil.price_by_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6326: AND NOT EXISTS ( SELECT name
6327: FROM qp_price_formulas_vl
6328: WHERE name = qpil.price_by_formula);
6329:
6330: --5. GENERATE USING FORMULA ID
6331:

Line 6357: FROM qp_price_formulas_vl

6353: AND qpil.generate_using_formula_id is NOT NULL
6354: AND qpil.generate_using_formula is NOT NULL
6355: AND qpil.generate_using_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6356: AND NOT EXISTS ( SELECT name
6357: FROM qp_price_formulas_vl
6358: WHERE price_formula_id = qpil.generate_using_formula_id
6359: AND name = qpil.generate_using_formula);
6360:
6361:

Line 6388: FROM qp_price_formulas_vl

6384: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6385: AND qpil.generate_using_formula_id is NOT NULL
6386: AND qpil.generate_using_formula is NULL
6387: AND NOT EXISTS ( SELECT name
6388: FROM qp_price_formulas_vl
6389: WHERE price_formula_id = qpil.generate_using_formula_id);
6390:
6391: INSERT INTO QP_INTERFACE_ERRORS
6392: (error_id,last_update_date, last_updated_by, creation_date,

Line 6410: FROM qp_price_formulas_vl

6406: AND qpil.generate_using_formula_id is NULL
6407: AND qpil.generate_using_formula is NOT NULL
6408: AND qpil.generate_using_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6409: AND NOT EXISTS ( SELECT name
6410: FROM qp_price_formulas_vl
6411: WHERE name = qpil.generate_using_formula);
6412:
6413: -- Bug# 5236656 RAVI
6414: IF SQL%ROWCOUNT >0 THEN