DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_CST_ETL_PKG dependencies on ISC_MAINT_WORK_ORDERS_F

Line 551: isc_maint_work_orders_f wo

547: , g_program_login_id
548: , g_program_application_id
549: , g_request_id
550: from
551: isc_maint_work_orders_f wo
552: , wip_eam_period_balances pb
553: where
554: wo.work_order_id = pb.wip_entity_id
555: and wo.organization_id = pb.organization_id

Line 891: isc_maint_work_orders_f wo

887: , wo.status_type
888: , wo.completion_date
889: , wo.closed_date
890: from
891: isc_maint_work_orders_f wo
892: , wip_eam_period_balances pb
893: where
894: pb.last_update_date >= l_collect_from_date
895: and wo.work_order_id = pb.wip_entity_id

Line 918: isc_maint_work_orders_f wo

914: , wo.status_type
915: , wo.completion_date
916: , wo.closed_date
917: from
918: isc_maint_work_orders_f wo
919: , wip_eam_period_balances pb
920: , isc_maint_wo_cst_sum_f f
921: where
922: wo.last_update_date >= l_collect_from_date

Line 963: isc_maint_work_orders_f wo

959: , 0 system_estimated_mat_cost
960: , 0 system_estimated_lab_cost
961: , 0 system_estimated_eqp_cost
962: from
963: isc_maint_work_orders_f wo
964: , isc_maint_wo_cst_sum_f f
965: where
966: wo.status_type in (4, 5, 12)
967: and wo.last_update_date >= l_collect_from_date