DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on BOM_RESOURCES

Line 1417: bom_resources br,

1413: wta.wip_sub_ledger_id c_wip_dr_sub_ledger_id,
1414: nvl2(ppf.npw_number,'CTW',null) c_person_type
1415: FROM wip_transaction_accounts wta,
1416: wip_transactions wt,
1417: bom_resources br,
1418: bom_departments bd,
1419: per_people_f ppf
1420: WHERE wt.transaction_type in (1,2,3)
1421: AND wta.accounting_line_type = 7

Line 2097: bom_resources br,

2093: br.resource_id resource_id,
2094: macs.cost_element_id cost_element_id,
2095: p_denom_currency_code denom_currency_code
2096: FROM mtl_actual_cost_subelement macs,
2097: bom_resources br,
2098: mtl_parameters mp
2099: WHERE macs.transaction_id = p_transaction_id
2100: AND macs.ORGANIZATION_ID = mp.ORGANIZATION_ID
2101: AND mp.cost_organization_id = br.organization_id

Line 2140: bom_resources br

2136: br.resource_id resource_id,
2137: macs.cost_element_id cost_element_id,
2138: l_xfer_currency_code denom_currency_code
2139: FROM mtl_actual_cost_subelement macs,
2140: bom_resources br
2141: WHERE macs.transaction_id = p_transfer_transaction_id
2142: AND macs.ORGANIZATION_ID = br.ORGANIZATION_ID
2143: AND macs.cost_element_id = 2
2144: AND macs.level_type = 1

Line 5250: bom_resources br,

5246: br.expenditure_type)
5247: INTO l_exp_type
5248: FROM mtl_parameters mp,
5249: cst_item_cost_details cicd,
5250: bom_resources br,
5251: bom_resources br1
5252: WHERE mp.organization_id = p_organization_id
5253: AND mp.cost_organization_id = cicd.organization_id (+)
5254: AND cicd.inventory_item_id (+) = p_inventory_item_id

Line 5251: bom_resources br1

5247: INTO l_exp_type
5248: FROM mtl_parameters mp,
5249: cst_item_cost_details cicd,
5250: bom_resources br,
5251: bom_resources br1
5252: WHERE mp.organization_id = p_organization_id
5253: AND mp.cost_organization_id = cicd.organization_id (+)
5254: AND cicd.inventory_item_id (+) = p_inventory_item_id
5255: AND cicd.cost_type_id (+) = decode(p_cost_method, 1, 1,

Line 5297: bom_resources br

5293: BEGIN
5294: SELECT 'NO VALUE'
5295: INTO l_exp_type
5296: FROM mtl_actual_cost_subelement macs,
5297: bom_resources br
5298: WHERE macs.transaction_id = p_transaction_id
5299: AND macs.organization_id = p_organization_id
5300: AND macs.cost_element_id = 2
5301: AND macs.level_type = 1