eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on WIP_DISCRETE_JOBS

Line 799: -- wip_discrete_jobs depending on the value of

795: -- If wip_entity_id is null,
796: -- ERR: 'PO_PDOI_COLUMN_NOT_NULL'
797: -- Else
798: -- Validate against wip_repetitive_schedules/
799: -- wip_discrete_jobs depending on the value of
800: -- wip_repetitive_schedule_id. (If the
801: -- destination_type_code = 'SHOP FLOOR', then if
802: -- WIP_REPETITIVE_SCHEDULE_ID is not null then the
803: -- record must be a repetitive schedule. If

Line 914: FROM wip_discrete_jobs wdj

910: AND p_wip_entity_id_tbl(i) IS NOT NULL
911: AND p_wip_rep_schedule_id_tbl(i) IS NULL
912: AND NOT EXISTS(
913: SELECT 1
914: FROM wip_discrete_jobs wdj
915: WHERE wdj.organization_id = p_destination_org_id_tbl(i)
916: AND wdj.wip_entity_id = p_wip_entity_id_tbl(i)
917: AND wdj.status_type IN(3, 4, 6));
918: