APPS.ASO_PRICING_CORE_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 7048: ASO_PRICE_ADJ_RELATIONSHIPS rlt

7044: --We won't need this since in the second implicit call the only Adj record for free line
7045: --is the PRG related DIS record.
7046: /*AND EXISTS ( SELECT null
7047: FROM ASO_PRICE_ADJUSTMENTS adj2,
7048: ASO_PRICE_ADJ_RELATIONSHIPS rlt
7049: WHERE rlt.rltd_price_adj_id = adj.price_adjustment_id
7050: AND adj2.modifier_line_type_code = 'PRG'
7051: AND adj2.quote_header_id = adj.quote_header_id
7052: AND adj2.price_adjustment_id = rlt.price_adjustment_id));*/

Line 7299: aso_price_adj_relationships rlt

7295: AND NVL(ASO_PRICING_INT.G_HEADER_REC.RECALCULATE_FLAG,'N') = 'N')
7296: OR ( adj.modifier_line_type_code = 'PRG'
7297: OR
7298: ( adj.modifier_line_type_code = 'DIS' and exists ( select null from aso_price_adjustments adj2,
7299: aso_price_adj_relationships rlt
7300: where rlt.rltd_price_adj_id = adj.price_adjustment_id
7301: and adj2.modifier_line_type_code = 'PRG'
7302: and adj2.quote_header_id = adj.quote_header_id
7303: and adj2.price_adjustment_id = rlt.price_adjustment_id))));

Line 7338: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,

7334: G_RLTD_RLTD_LINE_DTL_IND_TBL,
7335: G_RLTD_RELATED_LINE_IND_TBL,
7336: G_RLTD_LST_LN_ID_DEF_TBL,
7337: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7338: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7339: ASO_PRICE_ADJUSTMENTS dbadj,
7340: ASO_PRICE_ADJUSTMENTS dbadjrel,
7341: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7342: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7414: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,

7410: G_RLTD_RLTD_LINE_DTL_IND_TBL,
7411: G_RLTD_RELATED_LINE_IND_TBL,
7412: G_RLTD_LST_LN_ID_DEF_TBL,
7413: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7414: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7415: ASO_PRICE_ADJUSTMENTS dbadj,
7416: ASO_PRICE_ADJUSTMENTS dbadjrel,
7417: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7418: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 9685: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS

9681: * Insert to Price Adj Relationships
9682: *
9683: */
9684:
9685: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS
9686: (adj_relationship_id,
9687: creation_date,
9688: created_by,
9689: last_update_date,

Line 10005: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS

10001: * Insert to Price Adj Relationships
10002: *
10003: */
10004:
10005: INSERT INTO ASO_PRICE_ADJ_RELATIONSHIPS
10006: (adj_relationship_id,
10007: creation_date,
10008: created_by,
10009: last_update_date,