APPS.INV_WIP_PICKING_PVT dependencies on BOM_DEPARTMENTS

Line 1686: l_department_code bom_departments.department_code%TYPE;

1682: ) IS
1683: l_wip_entity_type NUMBER;
1684: l_repetitive_line_id NUMBER;
1685: l_department_id NUMBER;
1686: l_department_code bom_departments.department_code%TYPE;
1687: l_push_vs_pull VARCHAR2(4);
1688: l_pick_slip_number NUMBER;
1689: l_index NUMBER := 0;
1690: l_msg_data VARCHAR2(2000);

Line 1862: FROM wip_operations wo, bom_departments bd

1858: AND repetitive_schedule_id = p_rep_schedule_id;
1859:
1860: CURSOR c_discrete_dept IS
1861: SELECT wo.department_id, bd.department_code
1862: FROM wip_operations wo, bom_departments bd
1863: WHERE wo.wip_entity_id = p_wip_entity_id
1864: AND wo.organization_id = p_organization_id
1865: AND wo.operation_seq_num = p_operation_seq_num
1866: AND bd.department_id = wo.department_id;

Line 1870: FROM wip_operations wo, bom_departments bd

1866: AND bd.department_id = wo.department_id;
1867:
1868: CURSOR c_repetitive_dept IS
1869: SELECT wo.department_id, bd.department_code
1870: FROM wip_operations wo, bom_departments bd
1871: WHERE wo.wip_entity_id = p_wip_entity_id
1872: AND wo.organization_id = p_organization_id
1873: AND wo.operation_seq_num = p_operation_seq_num
1874: AND wo.repetitive_schedule_id = p_rep_schedule_id

Line 1879: FROM bom_departments bd

1875: AND bd.department_id = wo.department_id;
1876:
1877: CURSOR c_flow_dept IS
1878: SELECT bos.department_id, bd.department_code
1879: FROM bom_departments bd
1880: , bom_operation_sequences bos
1881: , bom_operational_routings bor
1882: , wip_flow_schedules wfs
1883: WHERE wfs.wip_entity_id = p_wip_entity_id