APPS.WMS_CONTAINER_PUB dependencies on WMS_LPN_HISTORIES

Line 4084: INSERT INTO wms_lpn_histories (

4080: END IF;
4081:
4082: IF p_unpack_inner_lpns = 'N' THEN
4083:
4084: INSERT INTO wms_lpn_histories (
4085: LPN_HISTORY_ID -- Sequence
4086: , SECONDARY_QUANTITY -- wlc.parent_lpn_id
4087: , SECONDARY_UOM_CODE --wlc.secondary_uom_code
4088: , CALLER

Line 4146: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID

4142: , OUTERMOST_LPN_ID --wlpn.outermost_lpn_id
4143: , OUTERMOST_LICENSE_PLATE_NUMBER -- Need to derive
4144: , HOMOGENEOUS_CONTAINER --wlpn.homogeneous_container
4145: ) SELECT
4146: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID
4147: , wlc.quantity -- SECONDARY_QUANTITY
4148: , wlc.secondary_uom_code -- SECONDARY_UOM_CODE
4149: , NULL -- CALLER
4150: , NULL -- SOURCE_TRANSACTION_ID

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

4212: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4213: AND wlpn1.lpn_id = p_lpn_id;
4214:
4215: IF l_debug = 1 THEN
4216: mdebug('Inserted wms_lpn_histories rows for lpn : '|| p_lpn_id);
4217: END IF;
4218:
4219: DELETE FROM wms_lpn_contents
4220: WHERE parent_lpn_id = p_lpn_id;

Line 4353: INSERT INTO wms_lpn_histories (

4349: FROM wms_license_plate_numbers
4350: WHERE lpn_id = all_child_wlpn_rec.lpn_id);
4351:
4352:
4353: INSERT INTO wms_lpn_histories (
4354: LPN_HISTORY_ID -- Sequence
4355: , SECONDARY_QUANTITY -- wlc.parent_lpn_id
4356: , SECONDARY_UOM_CODE --wlc.secondary_uom_code
4357: , CALLER

Line 4415: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID

4411: , OUTERMOST_LPN_ID --wlpn.outermost_lpn_id
4412: , OUTERMOST_LICENSE_PLATE_NUMBER -- Need to derive
4413: , HOMOGENEOUS_CONTAINER --wlpn.homogeneous_container
4414: ) SELECT
4415: wms_lpn_histories_s.NEXTVAL -- LPN_HISTORY_ID
4416: , wlc.quantity -- SECONDARY_QUANTITY
4417: , wlc.secondary_uom_code -- SECONDARY_UOM_CODE
4418: , NULL -- CALLER
4419: , NULL -- SOURCE_TRANSACTION_ID