APPS.CST_PRJMFG_COST_COLLECTOR dependencies on WIP_TRANSACTION_ACCOUNTS

Line 500: FROM wip_transaction_accounts wta

496: AND NOT EXISTS
497: (
498: SELECT
499: NULL
500: FROM wip_transaction_accounts wta
501: WHERE wta.transaction_id = wt.transaction_id
502: )
503: )
504: OR wt.source_code = 'IPV' -- Bug 2130771

Line 1380: FROM wip_transaction_accounts wta,

1376: wt.primary_uom c_primary_uom,
1377: wta.basis_resource_id c_basis_resource_id,
1378: wta.reference_account c_reference_account,
1379: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id
1380: FROM wip_transaction_accounts wta,
1381: wip_transactions wt,
1382: bom_resources br,
1383: bom_departments bd,
1384: per_people_f ppf

Line 1426: FROM wip_transaction_accounts wta,

1422: wt.primary_uom c_primary_uom,
1423: wta.basis_resource_id c_basis_resource_id,
1424: wta.reference_account c_reference_account,
1425: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id
1426: FROM wip_transaction_accounts wta,
1427: wip_transactions wt,
1428: pjm_project_parameters ppp,
1429: po_lines_all pla
1430: WHERE wt.transaction_type = 17

Line 1538: FROM wip_transaction_accounts

1534: */
1535:
1536: SELECT NVL(reference_account,-99)
1537: INTO l_cr_code_combination_id
1538: FROM wip_transaction_accounts
1539: WHERE transaction_id = p_transaction_id
1540: AND organization_id = p_org_id
1541: AND cost_element_id = wt_rec.c_cost_element_id
1542: AND accounting_line_type = l_accounting_line_type

Line 1551: FROM wip_transaction_accounts wta

1547: l_stmt_num := 16;
1548:
1549: SELECT MAX(WIP_SUB_LEDGER_ID)
1550: INTO l_wip_cr_sub_ledger_id
1551: FROM wip_transaction_accounts wta
1552: WHERE transaction_id = p_transaction_id
1553: AND reference_account = l_cr_code_combination_id
1554: AND organization_id = p_org_id
1555: AND cost_element_id = wt_rec.c_cost_element_id