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.WSH_WV_PVT dependencies on WSH_PACKED_CONTAINERS

Line 149: FROM wsh_packed_containers pc,

145: SELECT NVL(SUM( wsh_wv_pvt.convert_uom(msi.weight_uom_code, x_to_uom,
146: NVL(msi.unit_weight, 0))
147: * pc.quantity),
148: 0) tare_weight
149: FROM wsh_packed_containers pc,
150: mtl_system_items msi
151: WHERE msi.inventory_item_id = pc.container_inventory_item_id
152: AND pc.delivery_id = x_del_id
153: AND msi.organization_id = x_o_id;

Line 706: wsh_packed_containers pc,

702: IS
703: CURSOR container_fill(x_dep_id NUMBER, x_o_id NUMBER, x_veh_id NUMBER) IS
704: SELECT SUM(pc.quantity / cl.max_load_quantity) * 100
705: FROM wsh_container_load cl,
706: wsh_packed_containers pc,
707: wsh_deliveries d
708: WHERE d.actual_departure_id = x_dep_id
709: AND d.delivery_id = pc.delivery_id
710: AND pc.container_inventory_item_id = cl.load_item_id

Line 718: OR not exists (select sequence_number from wsh_packed_containers

714: FROM mtl_parameters
715: WHERE organization_id = x_o_id)
716: AND NVL(cl.max_load_quantity, 0) > 0
717: AND (pc.parent_sequence_number IS NULL
718: OR not exists (select sequence_number from wsh_packed_containers
719: where delivery_id = pc.delivery_id
720: and sequence_number = pc.parent_sequence_number))
721: GROUP BY 1;
722:

Line 956: FROM wsh_packed_containers pc,

952: IS
953: CURSOR delivery_volumes(x_del_id NUMBER, x_o_id NUMBER) IS
954: SELECT SUM(NVL(msi.unit_volume, 0) * pc.quantity) volume,
955: msi.volume_uom_code uom
956: FROM wsh_packed_containers pc,
957: mtl_system_items msi
958: WHERE msi.inventory_item_id = pc.container_inventory_item_id
959: AND pc.delivery_id = x_del_id
960: AND msi.organization_id = x_o_id

Line 962: OR not exists (select sequence_number from wsh_packed_containers

958: WHERE msi.inventory_item_id = pc.container_inventory_item_id
959: AND pc.delivery_id = x_del_id
960: AND msi.organization_id = x_o_id
961: AND (pc.parent_sequence_number IS NULL
962: OR not exists (select sequence_number from wsh_packed_containers
963: where delivery_id = pc.delivery_id
964: and sequence_number = pc.parent_sequence_number))
965: GROUP BY msi.volume_uom_code;
966:

Line 1211: FROM wsh_packed_containers pc,

1207: IS
1208: CURSOR delivery_weights(x_del_id NUMBER, x_o_id NUMBER) IS
1209: SELECT SUM(NVL(msi.unit_weight, 0) * pc.quantity) weight,
1210: msi.weight_uom_code uom
1211: FROM wsh_packed_containers pc,
1212: mtl_system_items msi
1213: WHERE msi.inventory_item_id = pc.container_inventory_item_id
1214: AND pc.delivery_id = x_del_id
1215: AND msi.organization_id = x_o_id

Line 1294: FROM wsh_packed_containers pc

1290: -- select other master containers whose parent_sequence_numbers
1291: -- are not NULL but not assigned to any other containers (or themselves).
1292: CURSOR sc_other_master_containers(x_del_id NUMBER) IS
1293: SELECT DISTINCT pc.parent_sequence_number
1294: FROM wsh_packed_containers pc
1295: WHERE pc.delivery_id = x_del_id
1296: AND pc.parent_sequence_number IS NOT NULL
1297: AND not exists (select sequence_number from wsh_packed_containers
1298: where delivery_id = pc.delivery_id

Line 1297: AND not exists (select sequence_number from wsh_packed_containers

1293: SELECT DISTINCT pc.parent_sequence_number
1294: FROM wsh_packed_containers pc
1295: WHERE pc.delivery_id = x_del_id
1296: AND pc.parent_sequence_number IS NOT NULL
1297: AND not exists (select sequence_number from wsh_packed_containers
1298: where delivery_id = pc.delivery_id
1299: and sequence_number = pc.parent_sequence_number);
1300:
1301: weight_c NUMBER := 0;

Line 1550: FROM wsh_packed_containers pc,

1546: pc.gross_weight weight,
1547: pc.weight_uom_code w_uom_code,
1548: msi.maximum_load_weight max_weight,
1549: msi.weight_uom_code mw_uom_code
1550: FROM wsh_packed_containers pc,
1551: mtl_system_items msi
1552: WHERE pc.delivery_id = x_del_id
1553: AND msi.inventory_item_id = pc.container_inventory_item_id
1554: AND msi.organization_id = x_o_id

Line 1654: FROM wsh_packed_containers pc,

1650: pc.container_inventory_item_id containter_inventory_item_id,
1651: pc.rowid rid,
1652: msi.unit_weight unit_weight,
1653: msi.weight_uom_code uom_code
1654: FROM wsh_packed_containers pc,
1655: mtl_system_items msi
1656: WHERE pc.delivery_id = x_del_id
1657: AND pc.container_inventory_item_id = msi.inventory_item_id
1658: AND msi.organization_id = x_o_id

Line 1780: UPDATE wsh_packed_containers

1776:
1777: -- 4. Now update the table.
1778: x_cont_weight := cont_weight;
1779: x_master_uom := master_uom;
1780: UPDATE wsh_packed_containers
1781: SET gross_weight = x_cont_weight,
1782: weight_uom_code = x_master_uom
1783: WHERE rowid = container.rid;
1784:

Line 2040: DELETE FROM wsh_packed_containers

2036:
2037: SAVEPOINT before_autopack;
2038:
2039: x_del_id := del_id;
2040: DELETE FROM wsh_packed_containers
2041: WHERE delivery_id = x_del_id;
2042:
2043: FOR c IN autopack_list(del_id, organization_id) LOOP
2044: IF (c.iid = current_container_item_id)

Line 2166: INSERT INTO wsh_packed_containers

2162: if current_user is null then
2163: current_user := 0;
2164: end if;
2165:
2166: INSERT INTO wsh_packed_containers
2167: (container_id, delivery_id,
2168: container_inventory_item_id, quantity,
2169: parent_sequence_number, sequence_number, -- sequences
2170: weight_uom_code, -- weight

Line 2175: (wsh_packed_containers_s.nextval, del_id,

2171: organization_id,
2172: creation_date, created_by, -- creation
2173: last_update_date, last_updated_by) -- update
2174: VALUES
2175: (wsh_packed_containers_s.nextval, del_id,
2176: cont_item_id, qty,
2177: parent_seq, load_seq_number, -- sequences
2178: weight_uom_code, -- weight
2179: organization_id,