DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1081: FROM mtl_material_transactions_temp

1077: SELECT '1'
1078: INTO charges_exist_3
1079: FROM dual
1080: WHERE EXISTS (SELECT '1'
1081: FROM mtl_material_transactions_temp
1082: WHERE organization_id = x_org_id
1083: AND transaction_source_type_id = 5
1084: AND transaction_source_id = x_wip_id);
1085: if charges_exist_3 = '1' then

Line 1353: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1349:
1350: begin
1351: SELECT DISTINCT '1'
1352: into charges_exist_3
1353: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1354: WHERE ORGANIZATION_ID = x_org_id
1355: AND TRANSACTION_SOURCE_TYPE_ID = 5
1356: AND TRANSACTION_SOURCE_ID = x_wip_id;
1357: exception

Line 1611: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

1607: BEGIN
1608:
1609: SELECT DISTINCT '1'
1610: INTO charges_exist_2
1611: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
1612: WHERE (ORGANIZATION_ID = p_org_id
1613: AND TRANSACTION_SOURCE_TYPE_ID = 5
1614: AND TRANSACTION_SOURCE_ID = p_wip_id
1615: AND rownum <=1)