DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on WIP_REQUIREMENT_OPERATIONS

Line 6805: -- wip_requirement_operations. Thus, operation_seq_num should not be null.

6801: FOR UPDATE NOWAIT;
6802:
6803: -- Cursor to lock the WIP demand record.
6804: -- WIP backordered component demand MUST have a record in the table
6805: -- wip_requirement_operations. Thus, operation_seq_num should not be null.
6806: -- We could also lock the wip_entities record but that is probably not necessary,
6807: -- especially if the demand is a WIP Repetitive job. That might lock up the record
6808: -- unnecessarily for other repetitive jobs with the same wip_entity_id.
6809: CURSOR lock_wip_record(p_wip_entity_id NUMBER,

Line 6813: FROM wip_requirement_operations

6809: CURSOR lock_wip_record(p_wip_entity_id NUMBER,
6810: p_operation_seq_num NUMBER,
6811: p_repetitive_schedule_id NUMBER) IS
6812: SELECT wip_entity_id
6813: FROM wip_requirement_operations
6814: WHERE inventory_item_id = l_inventory_item_id
6815: AND organization_id = l_organization_id
6816: AND wip_entity_id = p_wip_entity_id
6817: AND operation_seq_num = p_operation_seq_num