DBA Data[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_PRICE_ADJ_ATTRIBS

Line 9755: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

9751:
9752:
9753: -- Added hint to fix perf bug 5614878.
9754:
9755: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
9756: ( price_adj_attrib_id,
9757: creation_date,
9758: created_by,
9759: last_update_date,

Line 9770: ASO_PRICE_ADJ_ATTRIBS_S.nextval,

9766: pricing_attr_value_to,
9767: comparison_operator,
9768: flex_title)
9769: (SELECT /*+ ORDERED USE_NL(LINES LDETS QPLAT ADJ) INDEX(LINES) INDEX(LDETS) INDEX(QPLAT QP_PREQ_LINE_ATTRS_TMP_N3) */
9770: ASO_PRICE_ADJ_ATTRIBS_S.nextval,
9771: sysdate
9772: ,fnd_global.user_id
9773: ,sysdate
9774: ,fnd_global.user_id

Line 9807: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

9803: END IF;
9804:
9805: -- Added hint to fix perf bug 5614878.
9806:
9807: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
9808: ( price_adj_attrib_id,
9809: creation_date,
9810: created_by,
9811: last_update_date,

Line 9821: (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,

9817: pricing_attr_value_from,
9818: pricing_attr_value_to,
9819: comparison_operator,
9820: flex_title)
9821: (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,
9822: sysdate
9823: ,fnd_global.user_id
9824: ,sysdate
9825: ,fnd_global.user_id

Line 10074: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

10070:
10071:
10072: -- Added hint to fix perf bug 5614878.
10073:
10074: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
10075: ( price_adj_attrib_id,
10076: creation_date,
10077: created_by,
10078: last_update_date,

Line 10088: (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,

10084: pricing_attr_value_from,
10085: pricing_attr_value_to,
10086: comparison_operator,
10087: flex_title)
10088: (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,
10089: sysdate
10090: ,fnd_global.user_id
10091: ,sysdate
10092: ,fnd_global.user_id

Line 10240: INSERT INTO ASO_PRICE_ADJ_ATTRIBS

10236:
10237:
10238: -- Added hint to fix perf bug 5614878.
10239:
10240: INSERT INTO ASO_PRICE_ADJ_ATTRIBS
10241: ( price_adj_attrib_id,
10242: creation_date,
10243: created_by,
10244: last_update_date,

Line 10254: (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,

10250: pricing_attr_value_from,
10251: pricing_attr_value_to,
10252: comparison_operator,
10253: flex_title)
10254: (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,
10255: sysdate
10256: ,fnd_global.user_id
10257: ,sysdate
10258: ,fnd_global.user_id