APPS.CSTPAPBR dependencies on CST_REVENUE_COGS_MATCH_LINES

Line 6625: cst_revenue_cogs_match_lines crcml

6621: -- the Revenue / COGS Matching data model.
6622: SELECT max(ool.reference_line_id)
6623: INTO l_ref_om_line_id
6624: FROM oe_order_lines_all ool,
6625: cst_revenue_cogs_match_lines crcml
6626: WHERE ool.line_id = i_ae_txn_rec.om_line_id
6627: AND ool.reference_line_id = crcml.cogs_om_line_id
6628: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id
6629: AND i_ae_txn_rec.txn_src_type_id = 12;

Line 6685: FROM cst_revenue_cogs_match_lines

6681: l_stmt_num := 40;
6682: -- Get the Deferred COGS account
6683: SELECT deferred_cogs_acct_id
6684: INTO l_acct_rec.account
6685: FROM cst_revenue_cogs_match_lines
6686: WHERE cogs_om_line_id = i_ae_txn_rec.om_line_id
6687: AND pac_cost_type_id = i_ae_txn_rec.cost_type_id;
6688:
6689: l_acct_rec.mat_account := l_acct_rec.account;

Line 7015: cst_revenue_cogs_match_lines crcml

7011: -- the Revenue / COGS Matching data model.
7012: SELECT max(ool.reference_line_id)
7013: INTO l_ref_om_line_id
7014: FROM oe_order_lines_all ool,
7015: cst_revenue_cogs_match_lines crcml
7016: WHERE ool.line_id = i_ae_txn_rec.om_line_id
7017: AND ool.reference_line_id = crcml.cogs_om_line_id
7018: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id
7019: AND i_ae_txn_rec.txn_src_type_id = 12;

Line 7122: FROM cst_revenue_cogs_match_lines

7118: l_stmt_num := 50;
7119: -- Get the Deferred COGS account
7120: SELECT deferred_cogs_acct_id
7121: INTO l_acct_rec.account
7122: FROM cst_revenue_cogs_match_lines
7123: WHERE cogs_om_line_id = i_ae_txn_rec.om_line_id
7124: AND pac_cost_type_id = i_ae_txn_rec.cost_type_id;
7125:
7126: l_acct_line_type := 36; -- Deferred COGS line type