APPS.WIP_MTI_PUB dependencies on WIP_DISCRETE_JOBS

Line 670: from wip_discrete_jobs

666: end if; -- end of scheduled_flag = 1
667: else
668: select project_id, task_id
669: into l_projID, l_taskID
670: from wip_discrete_jobs
671: where wip_entity_id = pt_rec.transaction_source_id;
672: end if; -- end of flow_schedule = 'Y'
673:
674: if (pt_rec.transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,

Line 864: from wip_discrete_jobs wdj

860: and process_flag = 1
861: and transaction_source_type_id = 5
862: and ( ( mti.wip_entity_type in (1, 5, 6)
863: and not exists (select 'X'
864: from wip_discrete_jobs wdj
865: where wdj.wip_entity_id = mti.transaction_source_id
866: and wdj.organization_id = mti.organization_id
867: and wdj.status_type in (3,4)))
868: or ( mti.wip_entity_type = 2

Line 901: from wip_discrete_jobs wdj

897: and transaction_action_id in (WIP_CONSTANTS.SCRASSY_ACTION,
898: WIP_CONSTANTS.CPLASSY_ACTION,
899: WIP_CONSTANTS.RETASSY_ACTION)
900: and ( (exists (select 'X'
901: from wip_discrete_jobs wdj
902: where wdj.wip_entity_id = mti.transaction_source_id
903: and wdj.organization_id = mti.organization_id
904: and wdj.primary_item_id is null))
905: or ( upper(nvl(mti.flow_schedule, 'N')) = 'Y'

Line 1160: from wip_discrete_jobs wdj

1156: program_id = fnd_global.conc_program_id,
1157: program_update_date = sysdate,
1158: request_id = fnd_global.conc_request_id,
1159: revision = (select nvl(mti.revision, wdj.bom_revision)
1160: from wip_discrete_jobs wdj
1161: where wdj.organization_id = mti.organization_id
1162: and wdj.wip_entity_id = mti.transaction_source_id)
1163: where transaction_header_id = p_txnHeaderID
1164: and transaction_source_type_id = 5

Line 1472: from wip_discrete_jobs wdj

1468: and transaction_source_type_id = 5
1469: and transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1470: and ( wip_entity_type in (1,5)
1471: and (-1*primary_quantity > (select wdj.quantity_completed
1472: from wip_discrete_jobs wdj
1473: where wdj.organization_id = mti.organization_id
1474: and wdj.wip_entity_id = mti.transaction_source_id)));
1475:
1476: -- validate if asset item then cannot complete to expense sub.

Line 1553: from wip_discrete_jobs wdj

1549: and wrs.status_type in (3,4)))
1550: or ( mti.wip_entity_type in (1, 5, 6)
1551: and mti.transaction_date <
1552: (select wdj.date_released
1553: from wip_discrete_jobs wdj
1554: where wdj.wip_entity_id = mti.transaction_source_id
1555: and wdj.organization_id = mti.organization_id
1556: and wdj.status_type in (3, 4))));
1557:

Line 1859: from wip_discrete_jobs wdj,

1855: and wip_entity_type = 1 -- Discrete Jobs
1856: and transaction_source_id is not null
1857: and not exists
1858: (select 'x'
1859: from wip_discrete_jobs wdj,
1860: wip_entities we
1861: where wdj.wip_entity_id = mti.transaction_source_id
1862: and wdj.organization_id = mti.organization_id
1863: and wdj.wip_entity_id = we.wip_entity_id

Line 2522: from wip_discrete_jobs

2518: request_id = fnd_global.conc_request_id,
2519: (source_project_id, source_task_id) =
2520: (select project_id,
2521: task_id
2522: from wip_discrete_jobs
2523: where wip_entity_id = mti.transaction_source_id
2524: and organization_id = mti.organization_id)
2525: where transaction_header_id = p_txnHeaderID
2526: and process_flag = 1