APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 3175: -- longer has a corresponding record in Wsh_delivery_details, or a

3171: -- the same as closing a move order line. The user does not have
3172: -- access to a closed move order line - it's as if the line has been
3173: -- deleted. A cancelled move order line can still be transacted from
3174: -- the move order forms. However, a cancelled move order line no
3175: -- longer has a corresponding record in Wsh_delivery_details, or a
3176: -- reservation tied to that move order. A cancelled move order line
3177: -- is simply an inventory transaction, moving material from one subinventory
3178: -- to another. The allocations still exist for the move order line.
3179: -- This procedure updates the status on the move order line to 8 and

Line 3255: FROM wsh_delivery_details

3251:
3252: cursor c_txn_source_line IS
3253: SELECT source_line_id
3254: , organization_id
3255: FROM wsh_delivery_details
3256: WHERE move_order_line_id IS NOT NULL
3257: AND delivery_detail_id = p_delivery_detail_id
3258: AND move_order_line_id = p_line_id
3259: AND released_status = 'S';

Line 3655: FROM wsh_delivery_details

3651: AND inventory_Item_Id = l_inventory_Item_Id;
3652:
3653: cursor c_txn_source_line IS
3654: SELECT source_line_id
3655: FROM wsh_delivery_details
3656: WHERE move_order_line_id IS NOT NULL
3657: AND move_order_line_id = p_line_id
3658: AND released_status = 'S';
3659: