APPS.INV_WIP_PICKING_PVT dependencies on BOM_DEPARTMENTS

Line 1638: l_department_code bom_departments.department_code%TYPE;

1634: ) IS
1635: l_wip_entity_type NUMBER;
1636: l_repetitive_line_id NUMBER;
1637: l_department_id NUMBER;
1638: l_department_code bom_departments.department_code%TYPE;
1639: l_push_vs_pull VARCHAR2(4);
1640: l_pick_slip_number NUMBER;
1641: l_index NUMBER := 0;
1642: l_msg_data VARCHAR2(2000);

Line 1814: FROM wip_operations wo, bom_departments bd

1810: AND repetitive_schedule_id = p_rep_schedule_id;
1811:
1812: CURSOR c_discrete_dept IS
1813: SELECT wo.department_id, bd.department_code
1814: FROM wip_operations wo, bom_departments bd
1815: WHERE wo.wip_entity_id = p_wip_entity_id
1816: AND wo.organization_id = p_organization_id
1817: AND wo.operation_seq_num = p_operation_seq_num
1818: AND bd.department_id = wo.department_id;

Line 1822: FROM wip_operations wo, bom_departments bd

1818: AND bd.department_id = wo.department_id;
1819:
1820: CURSOR c_repetitive_dept IS
1821: SELECT wo.department_id, bd.department_code
1822: FROM wip_operations wo, bom_departments bd
1823: WHERE wo.wip_entity_id = p_wip_entity_id
1824: AND wo.organization_id = p_organization_id
1825: AND wo.operation_seq_num = p_operation_seq_num
1826: AND wo.repetitive_schedule_id = p_rep_schedule_id

Line 1831: FROM bom_departments bd

1827: AND bd.department_id = wo.department_id;
1828:
1829: CURSOR c_flow_dept IS
1830: SELECT bos.department_id, bd.department_code
1831: FROM bom_departments bd
1832: , bom_operation_sequences bos
1833: , bom_operational_routings bor
1834: , wip_flow_schedules wfs
1835: WHERE wfs.wip_entity_id = p_wip_entity_id