APPS.CSI_WIP_TRXS_PKG dependencies on WIP_DISCRETE_JOBS

Line 261: FROM wip_discrete_jobs

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

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

985: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
986: x_return_status OUT NOCOPY varchar2)
987: IS
988:
989: --l_inventory_item_id wip_discrete_jobs.primary_item_id%TYPE;
990: l_completion_quantity number;
991: l_relation_found varchar2(1) := 'N';
992:
993: -- get_item_instances variables

Line 1176: FROM wip_discrete_jobs

1172:
1173: BEGIN
1174: SELECT start_quantity
1175: INTO l_job_quantity
1176: FROM wip_discrete_jobs
1177: WHERE wip_entity_id = p_wip_entity_id
1178: AND organization_id = p_organization_id;
1179: EXCEPTION
1180: WHEN no_data_found THEN

Line 6830: FROM wip_discrete_jobs

6826: END LOOP;
6827:
6828: SELECT maintenance_object_id
6829: INTO l_instance_id
6830: FROM wip_discrete_jobs
6831: WHERE wip_entity_id = p_wip_entity_id
6832: AND organization_id = p_organization_id;
6833:
6834: debug(' parent_instance_id : '||l_instance_id);