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 4655: FROM WSH_CONTAINER_ITEMS

4651:
4652: CURSOR Get_Cont_Load (v_inv_item_id NUMBER, v_organization_id NUMBER) IS
4653: SELECT container_item_id,
4654: max_load_quantity
4655: FROM WSH_CONTAINER_ITEMS
4656: WHERE load_item_id = v_inv_item_id
4657: AND master_organization_id = v_organization_id
4658: AND preferred_flag = 'Y';
4659:

Line 5538: FROM WSH_CONTAINER_ITEMS

5534: ORDER BY wdd.organization_id,wdd.inventory_item_id,source_line_id;
5535:
5536: CURSOR Get_Cont_Item_Load (v_inv_item_id NUMBER, v_cont_item_id NUMBER, v_organization_id NUMBER) IS
5537: SELECT max_load_quantity
5538: FROM WSH_CONTAINER_ITEMS
5539: WHERE load_item_id = v_inv_item_id
5540: AND container_item_id = v_cont_item_id
5541: AND master_organization_id = v_organization_id;
5542:

Line 10446: FROM WSH_CONTAINER_ITEMS

10442: AND source_code = 'WSH';
10443:
10444: CURSOR Get_Cont_Item_Load (v_inv_item_id NUMBER, v_cont_item_id NUMBER, v_organization_id NUMBER) IS
10445: SELECT max_load_quantity
10446: FROM WSH_CONTAINER_ITEMS
10447: WHERE load_item_id = v_inv_item_id
10448: AND container_item_id = v_cont_item_id
10449: AND master_organization_id = v_organization_id;
10450: