APPS.CSI_WIP_TRXS_PKG dependencies on WIP_DISCRETE_JOBS

Line 263: FROM wip_discrete_jobs

259: l_txn_ref.wip_source_code,
260: l_txn_ref.wip_source_line_id,
261: l_txn_ref.wip_maint_obj_type,
262: l_txn_ref.wip_maint_obj_id
263: FROM wip_discrete_jobs
264: WHERE wip_entity_id = l_txn_ref.wip_entity_id
265: AND organization_id = l_txn_ref.organization_id;
266: END IF;
267: EXCEPTION

Line 1009: --l_inventory_item_id wip_discrete_jobs.primary_item_id%TYPE;

1005: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
1006: x_return_status OUT NOCOPY varchar2)
1007: IS
1008:
1009: --l_inventory_item_id wip_discrete_jobs.primary_item_id%TYPE;
1010: l_completion_quantity number;
1011: l_relation_found varchar2(1) := 'N';
1012:
1013: -- get_item_instances variables

Line 1196: FROM wip_discrete_jobs

1192:
1193: BEGIN
1194: SELECT start_quantity
1195: INTO l_job_quantity
1196: FROM wip_discrete_jobs
1197: WHERE wip_entity_id = p_wip_entity_id
1198: AND organization_id = p_organization_id;
1199: EXCEPTION
1200: WHEN no_data_found THEN

Line 7036: FROM wip_discrete_jobs

7032: END LOOP;
7033:
7034: SELECT maintenance_object_id
7035: INTO l_instance_id
7036: FROM wip_discrete_jobs
7037: WHERE wip_entity_id = p_wip_entity_id
7038: AND organization_id = p_organization_id;
7039:
7040: debug(' parent_instance_id : '||l_instance_id);