APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_CONTAINER_ITEMS

Line 78: cont_item_id WSH_CONTAINER_ITEMS.container_item_id%TYPE,

74: g_cache_organization_info_tab organization_info_tab;
75:
76: /* Organization specific Cache Table */
77: TYPE container_load_info IS RECORD (
78: cont_item_id WSH_CONTAINER_ITEMS.container_item_id%TYPE,
79: max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE);
80: TYPE container_load_info_tab IS TABLE OF container_load_info INDEX BY BINARY_INTEGER;
81: g_cache_cont_load_info_tab container_load_info_tab;
82:

Line 79: max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE);

75:
76: /* Organization specific Cache Table */
77: TYPE container_load_info IS RECORD (
78: cont_item_id WSH_CONTAINER_ITEMS.container_item_id%TYPE,
79: max_load_qty WSH_CONTAINER_ITEMS.max_load_quantity%TYPE);
80: TYPE container_load_info_tab IS TABLE OF container_load_info INDEX BY BINARY_INTEGER;
81: g_cache_cont_load_info_tab container_load_info_tab;
82:
83: /* Organization specific Cache Table */

Line 4727: FROM WSH_CONTAINER_ITEMS

4723:
4724: CURSOR Get_Cont_Load (v_inv_item_id NUMBER, v_organization_id NUMBER) IS
4725: SELECT container_item_id,
4726: max_load_quantity
4727: FROM WSH_CONTAINER_ITEMS
4728: WHERE load_item_id = v_inv_item_id
4729: AND master_organization_id = v_organization_id
4730: AND preferred_flag = 'Y';
4731:

Line 5610: FROM WSH_CONTAINER_ITEMS

5606: ORDER BY wdd.organization_id,wdd.inventory_item_id,source_line_id;
5607:
5608: CURSOR Get_Cont_Item_Load (v_inv_item_id NUMBER, v_cont_item_id NUMBER, v_organization_id NUMBER) IS
5609: SELECT max_load_quantity
5610: FROM WSH_CONTAINER_ITEMS
5611: WHERE load_item_id = v_inv_item_id
5612: AND container_item_id = v_cont_item_id
5613: AND master_organization_id = v_organization_id;
5614:

Line 10575: FROM WSH_CONTAINER_ITEMS

10571: AND source_code = 'WSH';
10572:
10573: CURSOR Get_Cont_Item_Load (v_inv_item_id NUMBER, v_cont_item_id NUMBER, v_organization_id NUMBER) IS
10574: SELECT max_load_quantity
10575: FROM WSH_CONTAINER_ITEMS
10576: WHERE load_item_id = v_inv_item_id
10577: AND container_item_id = v_cont_item_id
10578: AND master_organization_id = v_organization_id;
10579: