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.WIP_OSP dependencies on WIP_OPERATION_RESOURCES

Line 48: FROM WIP_OPERATION_RESOURCES WOR,

44: WO.COUNT_POINT_TYPE, WOR.AUTOCHARGE_TYPE,
45: decode (WO.PREVIOUS_OPERATION_SEQ_NUM, NULL, 'YES', 'NO') FIRST_OP,
46: WO.SCHEDULED_QUANTITY,
47: WE.ENTITY_TYPE
48: FROM WIP_OPERATION_RESOURCES WOR,
49: WIP_OPERATIONS WO,
50: WIP_DISCRETE_JOBS WDJ,
51: WIP_ENTITIES WE
52: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id

Line 72: FROM WIP_OPERATION_RESOURCES WOR,

68: NVL(WRS.PO_CREATION_TIME, 2) PO_CREATION_TIME,
69: WO.COUNT_POINT_TYPE, WOR.AUTOCHARGE_TYPE,
70: decode (WO.PREVIOUS_OPERATION_SEQ_NUM, NULL, 'YES', 'NO') FIRST_OP,
71: WO.SCHEDULED_QUANTITY
72: FROM WIP_OPERATION_RESOURCES WOR,
73: WIP_OPERATIONS WO,
74: WIP_REPETITIVE_SCHEDULES WRS
75: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
76: AND WO.ORGANIZATION_ID = P_Organization_Id

Line 138: wip_operation_resources wor,

134: l_osp_item_id := -1;
135: SELECT br.PURCHASE_ITEM_ID
136: into l_osp_item_id
137: from wip_entities we,
138: wip_operation_resources wor,
139: bom_resources br
140: where we.wip_entity_id = p_wip_entity_id
141: and we.organization_id = p_organization_id
142: and wor.wip_entity_id = we.wip_entity_id

Line 259: wip_operation_resources wor,

255: l_osp_item_id := -1;
256: SELECT br.PURCHASE_ITEM_ID
257: into l_osp_item_id
258: from wip_entities we,
259: wip_operation_resources wor,
260: bom_resources br
261: where we.wip_entity_id = p_wip_entity_id
262: and we.organization_id = p_organization_id
263: and wor.wip_entity_id = we.wip_entity_id

Line 447: from wip_operation_resources wor

443: and wo.organization_id = bd.organization_id
444: and bd.location_id IS NULL
445: and level < 3
446: and exists (select 1
447: from wip_operation_resources wor
448: where wor.wip_entity_id = P_Wip_Entity_Id
449: and wor.organization_id = P_Organization_Id
450: and wor.operation_seq_num = P_Operation_Seq_num
451: and wor.autocharge_type =

Line 616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

612: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
613: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
619: WHERE op1.organization_id = wor.organization_id
620: AND op1.wip_entity_id = wor.wip_entity_id

Line 809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

805: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
806: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
812: WHERE op1.organization_id = wor.organization_id
813: AND op1.wip_entity_id = wor.wip_entity_id

Line 1187: l_usage wip_operation_resources.usage_rate_or_amount%TYPE;

1183: P_WipOperationSeqNum IN NUMBER DEFAULT NULL,
1184: R_QaAvailable OUT NOCOPY VARCHAR2) IS
1185:
1186: l_qty NUMBER;
1187: l_usage wip_operation_resources.usage_rate_or_amount%TYPE;
1188: l_rev VARCHAR2(30);
1189: x_released_revs_type NUMBER ;
1190: x_released_revs_meaning Varchar2(30);
1191:

Line 1196: FROM wip_operation_resources wor

1192:
1193: BEGIN
1194: SELECT wor.usage_rate_or_amount
1195: INTO l_usage
1196: FROM wip_operation_resources wor
1197: WHERE wor.wip_entity_id = P_WipEntityId
1198: and NVL(wor.repetitive_schedule_id, -1) =
1199: NVL(P_WipRepetitiveScheduleId, -1)
1200: and wor.operation_seq_num = P_WipOperationSeqNum

Line 1292: wip_operation_resources wor,

1288: -- you cannot move into a queue of operation unless that department
1289: -- has a location set up
1290: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1291: FROM bom_departments bd,
1292: wip_operation_resources wor,
1293: wip_operations wo1,
1294: wip_operations wo2
1295: WHERE wor.organization_id = c_org_id
1296: AND wor.wip_entity_id = c_wip_entity_id

Line 1342: FROM wip_operation_resources wor

1338:
1339: -- you cannot forward move into a queue of operation that has
1340: -- PO resources unless you are an employee
1341: SELECT 'WIP_VALID_EMPLOYEE' error_message
1342: FROM wip_operation_resources wor
1343: WHERE wor.organization_id = c_org_id
1344: AND wor.wip_entity_id = c_wip_entity_id
1345: AND wor.operation_seq_num = c_to_op
1346: AND c_fm_op < c_to_op

Line 1957: wip_operation_resources wor,

1953: po_distributions_all pd,
1954: po_headers_all ph,
1955: po_lines_all pl,
1956: po_line_locations_all pll,
1957: wip_operation_resources wor,
1958: wip_operations wo,
1959: wip_discrete_jobs wdj,
1960: wip_repetitive_schedules wrs
1961: WHERE ph.type_lookup_code = 'STANDARD'

Line 2034: wip_operation_resources wor,

2030: po_headers_all ph,
2031: po_lines_all pl,
2032: po_line_locations_all pll,
2033: po_releases_all pr,
2034: wip_operation_resources wor,
2035: wip_operations wo,
2036: wip_discrete_jobs wdj,
2037: wip_repetitive_schedules wrs
2038: WHERE ph.type_lookup_code = 'BLANKET'

Line 2101: wip_operation_resources wor,

2097: prl.org_id ou_id -- operating unit
2098: FROM mtl_system_items msi,
2099: po_requisition_headers_all prh,
2100: po_requisition_lines_all prl,
2101: wip_operation_resources wor,
2102: wip_operations wo,
2103: wip_discrete_jobs wdj,
2104: wip_repetitive_schedules wrs
2105: WHERE NOT EXISTS

Line 2793: wip_operation_resources wor,

2789: BEGIN
2790: select count(1)
2791: into l_count
2792: from
2793: wip_operation_resources wor,
2794: wip_operations wo,
2795: bom_departments bd
2796: where
2797: wor.wip_entity_id = wo.wip_entity_id