APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_DISCRETE_JOBS

Line 1618: from wip_discrete_jobs wdj, mtl_system_items_kfv msi

1614: transaction_quantity,
1615: wdj.completion_subinventory, wdj.completion_locator_id,
1616: msi.primary_uom_code, msi.revision_qty_control_code,
1617: msi.SERIAL_NUMBER_CONTROL_CODE, msi.LOT_CONTROL_CODE
1618: from wip_discrete_jobs wdj, mtl_system_items_kfv msi
1619: where wdj.wip_entity_id = p_comp_job_dtls_rec.wip_entity_id and
1620: wdj.primary_item_id = msi.inventory_item_id and
1621: wdj.organization_id = msi.organization_id;
1622:

Line 4235: SELECT start_quantity from wip_discrete_jobs where

4231: l_op_exists VARCHAR2(10);
4232: l_op_dtls_tbl OP_DTLS_TBL_TYPE;
4233:
4234: CURSOR get_job_quantity ( p_wip_entity_id NUMBER ) IS
4235: SELECT start_quantity from wip_discrete_jobs where
4236: wip_entity_id = p_wip_entity_id ;
4237:
4238: CURSOR get_operation_exists(p_wip_entity_id NUMBER ) IS
4239: SELECT 'exists'

Line 4699: SELECT start_quantity from wip_discrete_jobs where

4695: l_resource_seq_num NUMBER;
4696:
4697:
4698: CURSOR get_job_quantity ( p_wip_entity_id NUMBER ) IS
4699: SELECT start_quantity from wip_discrete_jobs where
4700: wip_entity_id = p_wip_entity_id ;
4701:
4702: -- swai: bug 7017062 nvl the max(resource_seq_num)
4703: cursor get_next_resource_seq_num ( p_wip_entity_id NUMBER,