APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on BOM_RESOURCES

Line 59: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES

55: -- Fetches records that have the following warning -
56: -- 1. Billing item not defined for Resource.
57: CURSOR C_Resource_Item_Not_Defined IS
58: SELECT DISTINCT RES.resource_code
59: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES
60: WHERE WTXN.wip_entity_id = p_wip_entity_id
61: AND RES.resource_id = WTXN.resource_id
62: AND RES.billable_item_id IS NULL;
63:

Line 74: BOM_RESOURCES RES,

70: MSIW.concatenated_segments WIP_ITEM_NAME,
71: MSID.inventory_item_id DEPOT_ITEM_ID,
72: MSID.material_billable_flag BILLING_TYPE
73: FROM WIP_TRANSACTIONS WTXN,
74: BOM_RESOURCES RES,
75: MTL_SYSTEM_ITEMS_KFV MSIW,-- For WIP organization
76: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
77: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization
78: WHERE WTXN.wip_entity_id = p_wip_entity_id

Line 95: BOM_RESOURCES RES,

91: SELECT RES.billable_item_id INVENTORY_ITEM_ID,
92: SUM( NVL( WTXN.primary_quantity, 0 )) QUANTITY,
93: MSID.concatenated_segments DEPOT_ITEM_NAME
94: FROM WIP_TRANSACTIONS WTXN,
95: BOM_RESOURCES RES,
96: MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
97: WHERE WTXN.wip_entity_id = p_wip_entity_id
98: AND RES.resource_id = WTXN.resource_id
99: AND MSID.inventory_item_id = RES.billable_item_id

Line 1378: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,

1374: TXBT.txn_billing_type_id, TXBT.transaction_type_id,
1375: G_ACTUAL_SOURCE_CODE_WIP ACTUAL_SOURCE_CODE,
1376: l_wip_entity_id ACTUAL_SOURCE_ID,
1377: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
1378: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
1379: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
1380: CS_TXN_BILLING_TYPES TXBT
1381: WHERE WTXN.wip_entity_id = l_wip_entity_id
1382: AND WTXN.transaction_type IN( 1, 2, 3 )