APPS.ASO_PRICING_CORE_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 7063: ASO_PRICE_ADJ_RELATIONSHIPS rlt

7059: --We won't need this since in the second implicit call the only Adj record for free line
7060: --is the PRG related DIS record.
7061: /*AND EXISTS ( SELECT null
7062: FROM ASO_PRICE_ADJUSTMENTS adj2,
7063: ASO_PRICE_ADJ_RELATIONSHIPS rlt
7064: WHERE rlt.rltd_price_adj_id = adj.price_adjustment_id
7065: AND adj2.modifier_line_type_code = 'PRG'
7066: AND adj2.quote_header_id = adj.quote_header_id
7067: AND adj2.price_adjustment_id = rlt.price_adjustment_id));*/

Line 7315: aso_price_adj_relationships rlt

7311: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N')
7312: OR ( adj.modifier_line_type_code = 'PRG'
7313: OR
7314: ( adj.modifier_line_type_code = 'DIS' and exists ( select null from aso_price_adjustments adj2,
7315: aso_price_adj_relationships rlt
7316: where rlt.rltd_price_adj_id = adj.price_adjustment_id
7317: and adj2.modifier_line_type_code = 'PRG'
7318: and adj2.quote_header_id = adj.quote_header_id
7319: and adj2.price_adjustment_id = rlt.price_adjustment_id))));

Line 7354: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,

7350: G_RLTD_RLTD_LINE_DTL_IND_TBL,
7351: G_RLTD_RELATED_LINE_IND_TBL,
7352: G_RLTD_LST_LN_ID_DEF_TBL,
7353: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7354: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7355: ASO_PRICE_ADJUSTMENTS dbadj,
7356: ASO_PRICE_ADJUSTMENTS dbadjrel,
7357: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7358: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7430: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,

7426: G_RLTD_RLTD_LINE_DTL_IND_TBL,
7427: G_RLTD_RELATED_LINE_IND_TBL,
7428: G_RLTD_LST_LN_ID_DEF_TBL,
7429: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7430: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7431: ASO_PRICE_ADJUSTMENTS dbadj,
7432: ASO_PRICE_ADJUSTMENTS dbadjrel,
7433: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7434: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 9702: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS

9698: * Insert to Price Adj Relationships
9699: *
9700: */
9701:
9702: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS
9703: (adj_relationship_id,
9704: creation_date,
9705: created_by,
9706: last_update_date,

Line 10022: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS

10018: * Insert to Price Adj Relationships
10019: *
10020: */
10021:
10022: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS
10023: (adj_relationship_id,
10024: creation_date,
10025: created_by,
10026: last_update_date,