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 293: from wip_requirement_operations

289: into l_allocated,
290: l_backordered,
291: l_openQty,
292: l_rowid
293: from wip_requirement_operations
294: where wip_entity_id = p_wip_entity_id
295: and operation_seq_num = p_operation_seq_num
296: and inventory_item_id = p_inventory_item_id
297: for update of quantity_backordered, quantity_allocated nowait;

Line 316: from wip_requirement_operations

312: into l_allocated,
313: l_backordered,
314: l_openQty,
315: l_rowid
316: from wip_requirement_operations
317: where wip_entity_id = p_wip_entity_id
318: and operation_seq_num = p_operation_seq_num
319: and inventory_item_id = p_inventory_item_id
320: and repetitive_schedule_id = p_repetitive_schedule_id

Line 339: update wip_requirement_operations

335: -- raise fnd_api.G_EXC_UNEXPECTED_ERROR;
336: -- end if;
337:
338: if(p_primary_quantity > l_backordered) then
339: update wip_requirement_operations
340: set quantity_backordered = 0,
341: quantity_allocated = l_allocated + l_openQty
342: where rowid = l_rowid;
343: else

Line 345: update wip_requirement_operations

341: quantity_allocated = l_allocated + l_openQty
342: where rowid = l_rowid;
343: else
344: /* Fix for Bug#5962196. Added decode */
345: update wip_requirement_operations
346: set quantity_backordered = l_backordered - l_openQty,
347: quantity_allocated = decode(sign(l_allocated + l_openQty), -1, l_allocated, 0,
348: 0,
349: (l_allocated + l_openQty))

Line 557: from WIP_REQUIREMENT_OPERATIONS

553:
554: l_quantity_issued := p_quantity_issued;
555: if l_quantity_issued is null then
556: select quantity_issued into l_quantity_issued
557: from WIP_REQUIREMENT_OPERATIONS
558: where wip_entity_id = p_wip_entity_id
559: and operation_seq_num = p_operation_seq_num
560: and repetitive_schedule_id = p_repetitive_schedule_id
561: and organization_id = p_organization_id

Line 624: from wip_requirement_operations

620: INV_GLOBALS.G_TO_STATUS_PREAPPROVED)) ; -- preapproved or closed
621:
622: select quantity_allocated
623: into l_wro_quantity_allocated
624: from wip_requirement_operations
625: where wip_entity_id = p_wip_entity_id
626: and inventory_item_id = p_inventory_item_id
627: and operation_seq_num = p_operation_seq_num
628: and organization_id = p_organization_id

Line 663: from wip_requirement_operations

659: Begin
660: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
661: begin
662: Select 1 Into l_dummy
663: from wip_requirement_operations
664: Where wip_entity_id = p_wip_entity_id
665: And Organization_id = p_org_id
666: And operation_seq_num = p_operation_seq_num
667: And inventory_item_id = nvl(p_inventory_item_id, inventory_item_id)

Line 676: from wip_requirement_operations

672: end;
673: Else
674: begin
675: Select 1 Into l_dummy
676: from wip_requirement_operations
677: Where wip_entity_id = p_wip_entity_id
678: And repetitive_schedule_id = p_repetitive_schedule_id
679: And Organization_id = p_org_id
680: And operation_seq_num = p_operation_seq_num

Line 711: from wip_requirement_operations

707: Select 1 Into l_dummy
708: From dual
709: Where exists
710: (select 1
711: from wip_requirement_operations
712: Where wip_entity_id = p_wip_entity_id
713: And Organization_id = p_org_id
714: And quantity_backordered is not null);
715: exception

Line 725: from wip_requirement_operations

721: Select 1 Into l_dummy
722: From dual
723: Where exists
724: (select 1
725: from wip_requirement_operations
726: Where wip_entity_id = p_wip_entity_id
727: And repetitive_schedule_id = p_repetitive_schedule_id
728: And Organization_id = p_org_id
729: And quantity_backordered is not null);

Line 761: update wip_requirement_operations

757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758:
759: --for repetitive, lot-based and discrete...
760: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
761: update wip_requirement_operations
762: set supply_subinventory = p_supply_subinventory,
763: supply_locator_id = p_supply_locator_id
764: where wip_entity_id = p_wip_entity_id
765: and operation_seq_num = p_operation_seq_num

Line 769: update wip_requirement_operations

765: and operation_seq_num = p_operation_seq_num
766: and wip_supply_type in
767: (wip_constants.assy_pull, wip_constants.op_pull);
768: else
769: update wip_requirement_operations
770: set supply_subinventory = p_supply_subinventory,
771: supply_locator_id = p_supply_locator_id
772: where wip_entity_id = p_wip_entity_id
773: and operation_seq_num = p_operation_seq_num

Line 823: Update wip_requirement_operations wro

819: End if;
820:
821: --for repetitive, lot-based and discrete...
822: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
823: Update wip_requirement_operations wro
824: set quantity_backordered = GREATEST(p_new_component_qty
825: -- replaced wro.quantity_allocated with function quantity_allocated
826: -- - quantity_issued - quantity_allocated , 0)
827: - quantity_issued - wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

Line 840: Update wip_requirement_operations wro

836: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
837: or wip_supply_type = wip_constants.push
838: );
839: else
840: Update wip_requirement_operations wro
841: set quantity_backordered = GREATEST(p_new_component_qty
842: -- replaced wro.quantity_allocated with function quantity_allocated
843: -- - quantity_issued - quantity_allocated , 0)
844: - quantity_issued - wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,

Line 899: Update wip_requirement_operations wro

895: End if;
896:
897: --for repetitive, lot-based and discrete
898: if (p_repetitive_schedule_id is null or p_repetitive_schedule_id = 0) then
899: Update wip_requirement_operations wro
900: set quantity_backordered = GREATEST(p_new_job_qty* quantity_per_assembly -
901: wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
902: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, QUANTITY_ISSUED)
903: - quantity_issued, 0)

Line 915: Update wip_requirement_operations wro

911: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
912: or wip_supply_type = wip_constants.push
913: );
914: else
915: Update wip_requirement_operations wro
916: set quantity_backordered = GREATEST(p_new_job_qty* quantity_per_assembly
917: - wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
918: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID,QUANTITY_ISSUED)
919: - quantity_issued, 0)