DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on BOM_DEPARTMENTS

Line 103: TYPE dept_tab IS TABLE OF BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE INDEX BY BINARY_INTEGER;

99: TYPE rev_tab IS TABLE OF MTL_ITEM_REVISIONS.REVISION%TYPE INDEX BY BINARY_INTEGER;
100:
101: TYPE entity_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
102: TYPE line_tab IS TABLE OF WIP_LINES.LINE_CODE%TYPE INDEX BY BINARY_INTEGER;
103: TYPE dept_tab IS TABLE OF BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE INDEX BY BINARY_INTEGER;
104: TYPE schedule_tab IS TABLE OF WIP_ENTITIES.WIP_ENTITY_NAME%TYPE INDEX BY BINARY_INTEGER;
105:
106: TYPE ser_num_tab IS TABLE OF mtl_serial_numbers.serial_number%TYPE
107: INDEX BY BINARY_INTEGER;

Line 2275: l_dept BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE;

2271: l_wip_assembly_count NUMBER := 0;
2272:
2273: l_job WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;
2274: l_line WIP_LINES.LINE_CODE%TYPE;
2275: l_dept BOM_DEPARTMENTS.DEPARTMENT_CODE%TYPE;
2276: l_operation_seq_num NUMBER;
2277: l_wip_entity_type NUMBER;
2278: l_start_date DATE;
2279: l_schedule WIP_ENTITIES.WIP_ENTITY_NAME%TYPE;