APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on BOM_RESOURCES

Line 5456: BOM_RESOURCES RES

5452: QP_PRICE_LIST_LINES_V PRICE,
5453: MTL_SYSTEM_ITEMS_KFV MTL,
5454: CSD_REPAIR_TYPES_SAR RTSAR,
5455: CS_TXN_BILLING_TYPES SAR,
5456: BOM_RESOURCES RES
5457: WHERE ROSC.repair_line_id = p_repair_line_id
5458: and ROSC.applicable_flag = 'Y'
5459: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5460: and ROSC.applied_to_est_flag = 'N'

Line 5558: BOM_RESOURCES RES

5554: -- QP_PRICE_LIST_LINES_V PRICE,
5555: MTL_SYSTEM_ITEMS_KFV MTL,
5556: CSD_REPAIR_TYPES_SAR RTSAR,
5557: CS_TXN_BILLING_TYPES SAR,
5558: BOM_RESOURCES RES
5559: WHERE ROSC.repair_line_id = p_repair_line_id
5560: AND ROSC.applicable_flag = 'Y'
5561: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5562: AND ROSC.applied_to_est_flag = 'N'

Line 7746: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,

7742: G_ESTIMATE_SOURCE_CODE_WIP ESTIMATE_SOURCE_CODE,
7743: l_wip_entity_id ESTIMATE_SOURCE_ID,
7744: wtxn.operation_seq_num OPERATION_SEQ_NUM,
7745: RES.resource_id RESOURCE_ID -- Added for ER 3607765, vkjain.
7746: FROM WIP_TRANSACTIONS WTXN, BOM_RESOURCES RES,
7747: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
7748: CS_TXN_BILLING_TYPES TXBT
7749: WHERE WTXN.wip_entity_id = l_wip_entity_id
7750: AND WTXN.transaction_type IN( 1, 2, 3 )

Line 7793: CSD_WIP_TRANSACTION_DETAILS WTD, BOM_RESOURCES RES,

7789: l_wip_entity_id ESTIMATE_SOURCE_ID,
7790: WOR.operation_seq_num OPERATION_SEQ_NUM,
7791: RES.resource_id RESOURCE_ID
7792: FROM WIP_OPERATION_RESOURCES WOR, wip_operations wo,
7793: CSD_WIP_TRANSACTION_DETAILS WTD, BOM_RESOURCES RES,
7794: MTL_SYSTEM_ITEMS_KFV MSI, CSD_REPAIR_TYPES_SAR RTYP,
7795: CS_TXN_BILLING_TYPES TXBT
7796: WHERE WOR.wip_entity_id = l_wip_entity_id
7797: AND RES.resource_id = WOR.resource_id