DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 77: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization

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
79: AND RES.resource_id = WTXN.resource_id
80: AND MSIW.inventory_item_id = RES.billable_item_id
81: AND MSIW.organization_id = p_wip_organization

Line 295: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization

291: MSID.inventory_item_id DEPOT_ITEM_ID,
292: MSID.material_billable_flag BILLING_TYPE
293: FROM MTL_MATERIAL_TRANSACTIONS MMT,
294: MTL_SYSTEM_ITEMS_KFV MSIW, -- For WIP organization
295: MTL_SYSTEM_ITEMS_B MSID -- For Depot/Service organization
296: -- MTL_SYSTEM_ITEMS_KFV MSID -- For Depot/Service organization
297: WHERE MMT.transaction_source_id = p_wip_entity_id
298: AND MMT.transaction_source_type_id = G_MTL_TXN_SOURCE_TYPE_WIP
299: AND MMT.transaction_type_id IN( G_MTL_TXN_TYPE_COMP_ISSUE,