DBA Data[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_PRICE_ADJ_ATTRIBS

Line 9738: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

9734:
9735:
9736: -- Added hint to fix perf bug 5614878.
9737:
9738: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
9739: ( price_adj_attrib_id,
9740: creation_date,
9741: created_by,
9742: last_update_date,

Line 9753: ASO_PRICE_ADJ_ATTRIBS_S.nextval,

9749: pricing_attr_value_to,
9750: comparison_operator,
9751: flex_title)
9752: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
9753: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9754: sysdate
9755: ,fnd_global.user_id
9756: ,sysdate
9757: ,fnd_global.user_id

Line 9790: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

9786: END IF;
9787:
9788: -- Added hint to fix perf bug 5614878.
9789:
9790: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
9791: ( price_adj_attrib_id,
9792: creation_date,
9793: created_by,
9794: last_update_date,

Line 9804: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,

9800: pricing_attr_value_from,
9801: pricing_attr_value_to,
9802: comparison_operator,
9803: flex_title)
9804: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9805: sysdate
9806: ,fnd_global.user_id
9807: ,sysdate
9808: ,fnd_global.user_id

Line 10057: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

10053:
10054:
10055: -- Added hint to fix perf bug 5614878.
10056:
10057: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
10058: ( price_adj_attrib_id,
10059: creation_date,
10060: created_by,
10061: last_update_date,

Line 10071: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,

10067: pricing_attr_value_from,
10068: pricing_attr_value_to,
10069: comparison_operator,
10070: flex_title)
10071: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10072: sysdate
10073: ,fnd_global.user_id
10074: ,sysdate
10075: ,fnd_global.user_id

Line 10223: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

10219:
10220:
10221: -- Added hint to fix perf bug 5614878.
10222:
10223: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
10224: ( price_adj_attrib_id,
10225: creation_date,
10226: created_by,
10227: last_update_date,

Line 10237: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,

10233: pricing_attr_value_from,
10234: pricing_attr_value_to,
10235: comparison_operator,
10236: flex_title)
10237: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */ ASO_PRICE_ADJ_ATTRIBS_S.nextval,
10238: sysdate
10239: ,fnd_global.user_id
10240: ,sysdate
10241: ,fnd_global.user_id