APPS.QP_BULK_VALIDATE dependencies on QP_PRICE_FORMULAS_VL

Line 6271: FROM qp_price_formulas_vl

6267: AND qpil.price_by_formula_id is NOT NULL
6268: AND qpil.price_by_formula is NOT NULL
6269: AND qpil.price_by_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6270: AND NOT EXISTS ( SELECT name
6271: FROM qp_price_formulas_vl
6272: WHERE price_formula_id = qpil.price_by_formula_id
6273: AND name = qpil.price_by_formula);
6274:
6275: INSERT INTO QP_INTERFACE_ERRORS

Line 6293: FROM qp_price_formulas_vl

6289: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6290: AND qpil.price_by_formula_id is NOT NULL
6291: AND qpil.price_by_formula is NULL
6292: AND NOT EXISTS ( SELECT name
6293: FROM qp_price_formulas_vl
6294: WHERE price_formula_id = qpil.price_by_formula_id);
6295:
6296: INSERT INTO QP_INTERFACE_ERRORS
6297: (error_id,last_update_date, last_updated_by, creation_date,

Line 6315: FROM qp_price_formulas_vl

6311: AND qpil.price_by_formula_id is NULL
6312: AND qpil.price_by_formula is NOT NULL
6313: AND qpil.price_by_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6314: AND NOT EXISTS ( SELECT name
6315: FROM qp_price_formulas_vl
6316: WHERE name = qpil.price_by_formula);
6317:
6318: --5. GENERATE USING FORMULA ID
6319:

Line 6345: FROM qp_price_formulas_vl

6341: AND qpil.generate_using_formula_id is NOT NULL
6342: AND qpil.generate_using_formula is NOT NULL
6343: AND qpil.generate_using_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6344: AND NOT EXISTS ( SELECT name
6345: FROM qp_price_formulas_vl
6346: WHERE price_formula_id = qpil.generate_using_formula_id
6347: AND name = qpil.generate_using_formula);
6348:
6349:

Line 6376: FROM qp_price_formulas_vl

6372: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6373: AND qpil.generate_using_formula_id is NOT NULL
6374: AND qpil.generate_using_formula is NULL
6375: AND NOT EXISTS ( SELECT name
6376: FROM qp_price_formulas_vl
6377: WHERE price_formula_id = qpil.generate_using_formula_id);
6378:
6379: INSERT INTO QP_INTERFACE_ERRORS
6380: (error_id,last_update_date, last_updated_by, creation_date,

Line 6398: FROM qp_price_formulas_vl

6394: AND qpil.generate_using_formula_id is NULL
6395: AND qpil.generate_using_formula is NOT NULL
6396: AND qpil.generate_using_formula <> QP_BULK_LOADER_PUB.G_NULL_CHAR
6397: AND NOT EXISTS ( SELECT name
6398: FROM qp_price_formulas_vl
6399: WHERE name = qpil.generate_using_formula);
6400:
6401: -- Bug# 5236656 RAVI
6402: IF SQL%ROWCOUNT >0 THEN