DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on BOM_RESOURCES

Line 1382: bom_resources br,

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
1385: WHERE wt.transaction_type in (1,2,3)
1386: AND wta.accounting_line_type = 7

Line 2036: bom_resources br,

2032: br.resource_id resource_id,
2033: macs.cost_element_id cost_element_id,
2034: p_denom_currency_code denom_currency_code
2035: FROM mtl_actual_cost_subelement macs,
2036: bom_resources br,
2037: mtl_parameters mp
2038: WHERE macs.transaction_id = p_transaction_id
2039: AND macs.ORGANIZATION_ID = mp.ORGANIZATION_ID
2040: AND mp.cost_organization_id = br.organization_id

Line 2079: bom_resources br

2075: br.resource_id resource_id,
2076: macs.cost_element_id cost_element_id,
2077: l_xfer_currency_code denom_currency_code
2078: FROM mtl_actual_cost_subelement macs,
2079: bom_resources br
2080: WHERE macs.transaction_id = p_transfer_transaction_id
2081: AND macs.ORGANIZATION_ID = br.ORGANIZATION_ID
2082: AND macs.cost_element_id = 2
2083: AND macs.level_type = 1

Line 5189: bom_resources br,

5185: br.expenditure_type)
5186: INTO l_exp_type
5187: FROM mtl_parameters mp,
5188: cst_item_cost_details cicd,
5189: bom_resources br,
5190: bom_resources br1
5191: WHERE mp.organization_id = p_organization_id
5192: AND mp.cost_organization_id = cicd.organization_id (+)
5193: AND cicd.inventory_item_id (+) = p_inventory_item_id

Line 5190: bom_resources br1

5186: INTO l_exp_type
5187: FROM mtl_parameters mp,
5188: cst_item_cost_details cicd,
5189: bom_resources br,
5190: bom_resources br1
5191: WHERE mp.organization_id = p_organization_id
5192: AND mp.cost_organization_id = cicd.organization_id (+)
5193: AND cicd.inventory_item_id (+) = p_inventory_item_id
5194: AND cicd.cost_type_id (+) = decode(p_cost_method, 1, 1,

Line 5236: bom_resources br

5232: BEGIN
5233: SELECT 'NO VALUE'
5234: INTO l_exp_type
5235: FROM mtl_actual_cost_subelement macs,
5236: bom_resources br
5237: WHERE macs.transaction_id = p_transaction_id
5238: AND macs.organization_id = p_organization_id
5239: AND macs.cost_element_id = 2
5240: AND macs.level_type = 1