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 44: FROM WIP_OPERATION_RESOURCES WOR,

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

Line 68: FROM WIP_OPERATION_RESOURCES WOR,

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

Line 126: wip_operation_resources wor,

122: l_osp_item_id := -1;
123: SELECT br.PURCHASE_ITEM_ID
124: into l_osp_item_id
125: from wip_entities we,
126: wip_operation_resources wor,
127: bom_resources br
128: where we.wip_entity_id = p_wip_entity_id
129: and we.organization_id = p_organization_id
130: and wor.wip_entity_id = we.wip_entity_id

Line 246: wip_operation_resources wor,

242: l_osp_item_id := -1;
243: SELECT br.PURCHASE_ITEM_ID
244: into l_osp_item_id
245: from wip_entities we,
246: wip_operation_resources wor,
247: bom_resources br
248: where we.wip_entity_id = p_wip_entity_id
249: and we.organization_id = p_organization_id
250: and wor.wip_entity_id = we.wip_entity_id

Line 412: from wip_operation_resources wor

408: and wo.organization_id = bd.organization_id
409: and bd.location_id IS NULL
410: and level < 3
411: and exists (select 1
412: from wip_operation_resources wor
413: where wor.wip_entity_id = P_Wip_Entity_Id
414: and wor.organization_id = P_Organization_Id
415: and wor.operation_seq_num = P_Operation_Seq_num
416: and wor.autocharge_type =

Line 568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

564: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2,-- Bug 4398047 removed bcd1 and bcd2
565: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
571: WHERE op1.organization_id = wor.organization_id
572: AND op1.wip_entity_id = wor.wip_entity_id

Line 752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,

748: -- BOM_CALENDAR_DATES bcd1, BOM_CALENDAR_DATES bcd2, -- Bug 4398047 Commented out bcd1 and bcd2
749: BOM_CALENDAR_DATES bcd3, BOM_CALENDAR_DATES bcd4,
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
755: WHERE op1.organization_id = wor.organization_id
756: AND op1.wip_entity_id = wor.wip_entity_id

Line 1101: l_usage wip_operation_resources.usage_rate_or_amount%TYPE;

1097: P_WipOperationSeqNum IN NUMBER DEFAULT NULL,
1098: R_QaAvailable OUT NOCOPY VARCHAR2) IS
1099:
1100: l_qty NUMBER;
1101: l_usage wip_operation_resources.usage_rate_or_amount%TYPE;
1102: l_rev VARCHAR2(30);
1103: x_released_revs_type NUMBER ;
1104: x_released_revs_meaning Varchar2(30);
1105:

Line 1110: FROM wip_operation_resources wor

1106:
1107: BEGIN
1108: SELECT wor.usage_rate_or_amount
1109: INTO l_usage
1110: FROM wip_operation_resources wor
1111: WHERE wor.wip_entity_id = P_WipEntityId
1112: and NVL(wor.repetitive_schedule_id, -1) =
1113: NVL(P_WipRepetitiveScheduleId, -1)
1114: and wor.operation_seq_num = P_WipOperationSeqNum

Line 1206: wip_operation_resources wor,

1202: -- you cannot move into a queue of operation unless that department
1203: -- has a location set up
1204: SELECT 'WIP_PO_MOVE_LOCATION' error_message
1205: FROM bom_departments bd,
1206: wip_operation_resources wor,
1207: wip_operations wo1,
1208: wip_operations wo2
1209: WHERE wor.organization_id = c_org_id
1210: AND wor.wip_entity_id = c_wip_entity_id

Line 1256: FROM wip_operation_resources wor

1252:
1253: -- you cannot forward move into a queue of operation that has
1254: -- PO resources unless you are an employee
1255: SELECT 'WIP_VALID_EMPLOYEE' error_message
1256: FROM wip_operation_resources wor
1257: WHERE wor.organization_id = c_org_id
1258: AND wor.wip_entity_id = c_wip_entity_id
1259: AND wor.operation_seq_num = c_to_op
1260: AND c_fm_op < c_to_op

Line 1849: wip_operation_resources wor,

1845: po_distributions_all pd,
1846: po_headers_all ph,
1847: po_lines_all pl,
1848: po_line_locations_all pll,
1849: wip_operation_resources wor,
1850: wip_operations wo,
1851: wip_discrete_jobs wdj,
1852: wip_repetitive_schedules wrs
1853: WHERE ph.type_lookup_code = 'STANDARD'

Line 1913: wip_operation_resources wor,

1909: po_headers_all ph,
1910: po_lines_all pl,
1911: po_line_locations_all pll,
1912: po_releases_all pr,
1913: wip_operation_resources wor,
1914: wip_operations wo,
1915: wip_discrete_jobs wdj,
1916: wip_repetitive_schedules wrs
1917: WHERE ph.type_lookup_code = 'BLANKET'

Line 1980: wip_operation_resources wor,

1976: prl.org_id ou_id -- operating unit
1977: FROM mtl_system_items msi,
1978: po_requisition_headers_all prh,
1979: po_requisition_lines_all prl,
1980: wip_operation_resources wor,
1981: wip_operations wo,
1982: wip_discrete_jobs wdj,
1983: wip_repetitive_schedules wrs
1984: WHERE NOT EXISTS