DBA Data[Home] [Help]

APPS.INV_WIP_PICKING_PVT dependencies on WIP_OPERATIONS

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