APPS.CSTPAPBR dependencies on CST_REVENUE_COGS_MATCH_LINES

Line 6340: cst_revenue_cogs_match_lines crcml

6336: -- the Revenue / COGS Matching data model.
6337: SELECT max(ool.reference_line_id)
6338: INTO l_ref_om_line_id
6339: FROM oe_order_lines_all ool,
6340: cst_revenue_cogs_match_lines crcml
6341: WHERE ool.line_id = i_ae_txn_rec.om_line_id
6342: AND ool.reference_line_id = crcml.cogs_om_line_id
6343: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id
6344: AND i_ae_txn_rec.txn_src_type_id = 12;

Line 6381: FROM cst_revenue_cogs_match_lines

6377: l_stmt_num := 40;
6378: -- Get the Deferred COGS account
6379: SELECT deferred_cogs_acct_id
6380: INTO l_acct_rec.account
6381: FROM cst_revenue_cogs_match_lines
6382: WHERE cogs_om_line_id = i_ae_txn_rec.om_line_id
6383: AND pac_cost_type_id = i_ae_txn_rec.cost_type_id;
6384:
6385: l_acct_rec.mat_account := l_acct_rec.account;

Line 6707: cst_revenue_cogs_match_lines crcml

6703: -- the Revenue / COGS Matching data model.
6704: SELECT max(ool.reference_line_id)
6705: INTO l_ref_om_line_id
6706: FROM oe_order_lines_all ool,
6707: cst_revenue_cogs_match_lines crcml
6708: WHERE ool.line_id = i_ae_txn_rec.om_line_id
6709: AND ool.reference_line_id = crcml.cogs_om_line_id
6710: AND crcml.pac_cost_type_id = i_ae_txn_rec.cost_type_id
6711: AND i_ae_txn_rec.txn_src_type_id = 12;

Line 6748: FROM cst_revenue_cogs_match_lines

6744: l_stmt_num := 50;
6745: -- Get the Deferred COGS account
6746: SELECT deferred_cogs_acct_id
6747: INTO l_acct_rec.account
6748: FROM cst_revenue_cogs_match_lines
6749: WHERE cogs_om_line_id = i_ae_txn_rec.om_line_id
6750: AND pac_cost_type_id = i_ae_txn_rec.cost_type_id;
6751:
6752: l_acct_line_type := 36; -- Deferred COGS line type