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_PICKING_PVT dependencies on WIP_OPERATIONS

Line 916: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

912: wro.wip_supply_type,
913: wro.date_required,
914: msi.revision_qty_control_code
915:
916: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
917: where wro.wip_entity_id = v_wip_entity_id
918: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
919: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
920: and (

Line 962: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

958: wro.wip_supply_type,
959: wro.date_required,
960: msi.revision_qty_control_code
961:
962: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
963: where wro.wip_entity_id = v_wip_entity_id
964: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
965: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
966: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 1002: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi

998: wro.wip_supply_type,
999: wro.date_required,
1000: msi.revision_qty_control_code
1001:
1002: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi
1003: where wro.wip_entity_id = v_wip_entity_id
1004: and wro.wip_entity_id = wo.wip_entity_id
1005: and wro.operation_seq_num = wo.operation_seq_num
1006: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */

Line 1052: wip_operations wo

1048:
1049: from wip_requirement_operations wro,
1050: wip_repetitive_schedules wrs,
1051: mtl_system_items_b msi,
1052: wip_operations wo
1053: where wro.repetitive_schedule_id = v_rep_sched_id
1054: and wrs.repetitive_schedule_id = v_rep_sched_id
1055: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
1056: and ((p_cutoff_date is null) OR (wro.date_required <= p_cutoff_date))

Line 1854: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

1850: l_supplyType,
1851: l_reqDate,
1852: l_revControlCode
1853:
1854: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1855: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1856: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1857: and (
1858: ( 'Y' = (select allocate_backflush_components

Line 1898: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo

1894: l_supplyType,
1895: l_reqDate,
1896: l_revControlCode
1897:
1898: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1899: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1900: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1901: and wro.required_quantity > (wro.quantity_issued +
1902: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

Line 1934: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi

1930: l_supplyType,
1931: l_reqDate,
1932: l_revControlCode
1933:
1934: from wip_requirement_operations wro, wip_operations wo, mtl_system_items_b msi
1935: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1936: and wro.wip_entity_id = wo.wip_entity_id
1937: and wro.operation_seq_num = p_alloc_comp_tbl(i).operation_seq_num
1938: and wro.operation_seq_num = wo.operation_seq_num

Line 1983: wip_operations wo

1979:
1980: from wip_requirement_operations wro,
1981: wip_repetitive_schedules wrs,
1982: mtl_system_items_b msi,
1983: wip_operations wo
1984: where wro.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
1985: and wrs.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
1986: and ((p_cutoff_date is null) OR (wro.date_required < p_cutoff_date))
1987: and (

Line 2174: wip_operations wo

2170: from wip_entities we,
2171: wip_discrete_jobs wdj,
2172: wip_requirement_operations wro,
2173: wip_parameters wp,
2174: wip_operations wo
2175: where we.wip_entity_id = wdj.wip_entity_id
2176: and we.entity_type = 1
2177: and wdj.status_type in (3,4)
2178: and wdj.job_type = decode(p_job_type, 4, wdj.job_type, p_job_type) /*Bug 5932126 (FP of 5880558): Added to check job type*/

Line 2203: wip_operations wo

2199: from wip_entities we,
2200: wip_discrete_jobs wdj,
2201: wip_requirement_operations wro,
2202: wip_parameters wp,
2203: wip_operations wo
2204: where wo.wip_entity_id = we.wip_entity_id
2205: and wo.operation_seq_num = wro.operation_seq_num
2206: and we.wip_entity_id = wdj.wip_entity_id
2207: and we.entity_type = 5

Line 2241: wip_operations wo

2237: wip_repetitive_items wri,
2238: wip_requirement_operations wro,
2239: wip_parameters wp,
2240: wip_lines wl,
2241: wip_operations wo
2242: where we.wip_entity_id = wrs.wip_entity_id
2243: and wrs.repetitive_schedule_id = wro.repetitive_schedule_id
2244: and we.wip_entity_id = wri.wip_entity_id
2245: and we.primary_item_id = msik.inventory_item_id