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_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 37: update wip_requirement_operations

33:
34: --for repetitive, lot-based and discrete...
35: if(p_repetitive_schedule_id IS NULL) then
36: if(p_use_pickset_flag = 'N') then
37: update wip_requirement_operations
38: set quantity_backordered = p_allocate_quantity,
39: last_update_date = l_sysDate,
40: last_updated_by = l_userId,
41: last_update_login = l_loginId

Line 48: update wip_requirement_operations

44: and operation_seq_num = p_operation_seq_num;
45: end if;
46: else
47: if(p_use_pickset_flag = 'N') then
48: update wip_requirement_operations
49: set quantity_backordered = p_allocate_quantity,
50: last_update_date = l_sysDate,
51: last_updated_by = l_userId,
52: last_update_login = l_loginId

Line 102: FROM WIP_REQUIREMENT_OPERATIONS WRO,

98: WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)) open_quantity,
99: -- wro.quantity_allocated
100: wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM, WRO.ORGANIZATION_ID,
101: WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID,WRO.QUANTITY_ISSUED) quantity_allocated
102: FROM WIP_REQUIREMENT_OPERATIONS WRO,
103: WIP_REPETITIVE_SCHEDULES WRS
104: WHERE WRO.WIP_ENTITY_ID = p_wip_entity_id
105: AND WRO.INVENTORY_ITEM_ID = p_inventory_item_id
106: AND WRO.OPERATION_SEQ_NUM = p_operation_seq_num

Line 126: from wip_discrete_jobs wdj, wip_requirement_operations wro

122:
123: if(l_entityType <> wip_constants.REPETITIVE) then
124: select wdj.status_type
125: into l_status
126: from wip_discrete_jobs wdj, wip_requirement_operations wro
127: where wdj.wip_entity_id = p_wip_entity_id
128: and wro.wip_entity_id = wdj.wip_entity_id
129: and wro.inventory_item_id = p_inventory_item_id
130: and wro.operation_seq_num = p_operation_seq_num

Line 145: update wip_requirement_operations

141: end if;
142:
143: --up issued
144: --lower allocated
145: update wip_requirement_operations
146: set quantity_issued = quantity_issued - p_primary_quantity,
147: quantity_allocated = greatest(0, quantity_allocated + p_primary_quantity)
148: where wip_entity_id = p_wip_entity_id
149: and operation_seq_num = p_operation_seq_num

Line 163: update wip_requirement_operations

159: else
160: l_updQty := l_rmnQty;
161: l_rmnQty := 0;
162: end if;
163: update wip_requirement_operations
164: set quantity_issued = quantity_issued + l_updQty,
165: quantity_allocated = greatest(0, quantity_allocated - l_updQty)
166: where repetitive_schedule_id = l_rec.repetitive_schedule_id
167: and operation_seq_num = p_operation_seq_num

Line 199: update wip_requirement_operations

195: l_repSchedID := l_rec.repetitive_schedule_id;
196: end loop;
197: if(l_rmnQty > 0) then
198: --apply remaining qty to last open schedule
199: update wip_requirement_operations
200: set quantity_issued = quantity_issued + l_rmnQty,
201: quantity_allocated = 0
202: where repetitive_schedule_id = l_repSchedID
203: and operation_seq_num = p_operation_seq_num

Line 300: from wip_requirement_operations

296: into l_allocated,
297: l_backordered,
298: l_openQty,
299: l_rowid
300: from wip_requirement_operations
301: where wip_entity_id = p_wip_entity_id
302: and operation_seq_num = p_operation_seq_num
303: and inventory_item_id = p_inventory_item_id
304: for update of quantity_backordered, quantity_allocated nowait;

Line 323: from wip_requirement_operations

319: into l_allocated,
320: l_backordered,
321: l_openQty,
322: l_rowid
323: from wip_requirement_operations
324: where wip_entity_id = p_wip_entity_id
325: and operation_seq_num = p_operation_seq_num
326: and inventory_item_id = p_inventory_item_id
327: and repetitive_schedule_id = p_repetitive_schedule_id

Line 346: update wip_requirement_operations

342: -- raise fnd_api.G_EXC_UNEXPECTED_ERROR;
343: -- end if;
344:
345: if(p_primary_quantity > l_backordered) then
346: update wip_requirement_operations
347: set quantity_backordered = 0,
348: quantity_allocated = l_allocated + l_openQty
349: where rowid = l_rowid;
350: else

Line 352: update wip_requirement_operations

348: quantity_allocated = l_allocated + l_openQty
349: where rowid = l_rowid;
350: else
351: /* Fix for Bug#5962196. Added decode */
352: update wip_requirement_operations
353: set quantity_backordered = l_backordered - l_openQty,
354: quantity_allocated = decode(sign(l_allocated + l_openQty), -1, l_allocated, 0,
355: 0,
356: (l_allocated + l_openQty))

Line 566: from WIP_REQUIREMENT_OPERATIONS

562:
563: l_quantity_issued := p_quantity_issued;
564: if l_quantity_issued is null then
565: select quantity_issued into l_quantity_issued
566: from WIP_REQUIREMENT_OPERATIONS
567: where wip_entity_id = p_wip_entity_id
568: and operation_seq_num = p_operation_seq_num
569: and repetitive_schedule_id = p_repetitive_schedule_id
570: and organization_id = p_organization_id

Line 633: from wip_requirement_operations

629: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed
630:
631: select quantity_allocated
632: into l_wro_quantity_allocated
633: from wip_requirement_operations
634: where wip_entity_id = p_wip_entity_id
635: and inventory_item_id = p_inventory_item_id
636: and operation_seq_num = p_operation_seq_num
637: and organization_id = p_organization_id

Line 675: from wip_requirement_operations

671: /*Bug 12861942 The original query don't make sense because its purpose is for checking if
672: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
673: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
674: Select 1 Into l_dummy
675: from wip_requirement_operations
676: Where wip_entity_id = p_wip_entity_id
677: And Organization_id = p_org_id
678: And operation_seq_num = p_operation_seq_num
679: And inventory_item_id = nvl(p_inventory_item_id, inventory_item_id)

Line 702: from wip_requirement_operations

698: there are existing/pending move order lines, while quantity_backordered doesn't have much relation
699: existing/pending move order, modified query below to use MTL_TXN_REQUEST_LINES instead
700:
701: Select 1 Into l_dummy
702: from wip_requirement_operations
703: Where wip_entity_id = p_wip_entity_id
704: And repetitive_schedule_id = p_repetitive_schedule_id
705: And Organization_id = p_org_id
706: And operation_seq_num = p_operation_seq_num

Line 749: from wip_requirement_operations

745: Select 1 Into l_dummy
746: From dual
747: Where exists
748: (select 1
749: from wip_requirement_operations
750: Where wip_entity_id = p_wip_entity_id
751: And Organization_id = p_org_id
752: And quantity_backordered is not null
753: And quantity_backordered <> 0);

Line 773: from wip_requirement_operations

769: Select 1 Into l_dummy
770: From dual
771: Where exists
772: (select 1
773: from wip_requirement_operations
774: Where wip_entity_id = p_wip_entity_id
775: And repetitive_schedule_id = p_repetitive_schedule_id
776: And Organization_id = p_org_id
777: And quantity_backordered is not null

Line 818: update wip_requirement_operations

814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: --for repetitive, lot-based and discrete...
817: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
818: update wip_requirement_operations
819: set supply_subinventory = p_supply_subinventory,
820: supply_locator_id = p_supply_locator_id
821: where wip_entity_id = p_wip_entity_id
822: and operation_seq_num = p_operation_seq_num

Line 826: update wip_requirement_operations

822: and operation_seq_num = p_operation_seq_num
823: and wip_supply_type in
824: (wip_constants.assy_pull, wip_constants.op_pull);
825: else
826: update wip_requirement_operations
827: set supply_subinventory = p_supply_subinventory,
828: supply_locator_id = p_supply_locator_id
829: where wip_entity_id = p_wip_entity_id
830: and operation_seq_num = p_operation_seq_num

Line 880: Update wip_requirement_operations wro

876: End if;
877:
878: --for repetitive, lot-based and discrete...
879: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
880: Update wip_requirement_operations wro
881: set quantity_backordered = GREATEST(p_new_component_qty
882: -- replaced wro.quantity_allocated with function quantity_allocated
883: -- - quantity_issued - quantity_allocated , 0)
884: - quantity_issued - wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

Line 897: Update wip_requirement_operations wro

893: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
894: or wip_supply_type = wip_constants.push
895: );
896: else
897: Update wip_requirement_operations wro
898: set quantity_backordered = GREATEST(p_new_component_qty
899: -- replaced wro.quantity_allocated with function quantity_allocated
900: -- - quantity_issued - quantity_allocated , 0)
901: - quantity_issued - wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

Line 956: Update wip_requirement_operations wro

952: End if;
953:
954: --for repetitive, lot-based and discrete
955: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
956: Update wip_requirement_operations wro
957: set quantity_backordered = GREATEST(p_new_job_qty* quantity_per_assembly -
958: wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
959: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, QUANTITY_ISSUED)
960: - quantity_issued, 0)

Line 972: Update wip_requirement_operations wro

968: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
969: or wip_supply_type = wip_constants.push
970: );
971: else
972: Update wip_requirement_operations wro
973: set quantity_backordered = GREATEST(p_new_job_qty* quantity_per_assembly
974: - wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
975: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID,QUANTITY_ISSUED)
976: - quantity_issued, 0)