APPS.WMS_CONTAINER_PUB dependencies on WMS_LPN_HISTORIES

Line 4006: INSERT INTO wms_lpn_histories (

4002: END IF;
4003:
4004: IF p_unpack_inner_lpns = 'N' THEN
4005:
4006: INSERT INTO wms_lpn_histories (
4007: LPN_HISTORY_ID -- Sequence
4008: , SECONDARY_QUANTITY -- wlc.parent_lpn_id
4009: , SECONDARY_UOM_CODE --wlc.secondary_uom_code
4010: , CALLER

Line 4068: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID

4064: , OUTERMOST_LPN_ID --wlpn.outermost_lpn_id
4065: , OUTERMOST_LICENSE_PLATE_NUMBER -- Need to derive
4066: , HOMOGENEOUS_CONTAINER --wlpn.homogeneous_container
4067: ) SELECT
4068: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID
4069: , wlc.quantity -- SECONDARY_QUANTITY
4070: , wlc.secondary_uom_code -- SECONDARY_UOM_CODE
4071: , NULL -- CALLER
4072: , NULL -- SOURCE_TRANSACTION_ID

Line 4138: mdebug('Inserted wms_lpn_histories rows for lpn : '|| p_lpn_id);

4134: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4135: AND wlpn1.lpn_id = p_lpn_id;
4136:
4137: IF l_debug = 1 THEN
4138: mdebug('Inserted wms_lpn_histories rows for lpn : '|| p_lpn_id);
4139: END IF;
4140:
4141: DELETE FROM wms_lpn_contents
4142: WHERE parent_lpn_id = p_lpn_id;

Line 4275: INSERT INTO wms_lpn_histories (

4271: FROM wms_license_plate_numbers
4272: WHERE lpn_id = all_child_wlpn_rec.lpn_id);
4273:
4274:
4275: INSERT INTO wms_lpn_histories (
4276: LPN_HISTORY_ID -- Sequence
4277: , SECONDARY_QUANTITY -- wlc.parent_lpn_id
4278: , SECONDARY_UOM_CODE --wlc.secondary_uom_code
4279: , CALLER

Line 4337: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID

4333: , OUTERMOST_LPN_ID --wlpn.outermost_lpn_id
4334: , OUTERMOST_LICENSE_PLATE_NUMBER -- Need to derive
4335: , HOMOGENEOUS_CONTAINER --wlpn.homogeneous_container
4336: ) SELECT
4337: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID
4338: , wlc.quantity -- SECONDARY_QUANTITY
4339: , wlc.secondary_uom_code -- SECONDARY_UOM_CODE
4340: , NULL -- CALLER
4341: , NULL -- SOURCE_TRANSACTION_ID