APPS.WIP_MTI_PUB dependencies on WIP_DISCRETE_JOBS

Line 685: from wip_discrete_jobs

681: end if; -- end of scheduled_flag = 1
682: else
683: select project_id, task_id
684: into l_projID, l_taskID
685: from wip_discrete_jobs
686: where wip_entity_id = pt_rec.transaction_source_id;
687: end if; -- end of flow_schedule = 'Y'
688:
689: if (pt_rec.transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,

Line 887: from wip_discrete_jobs wdj

883: and process_flag = 1
884: and transaction_source_type_id = 5
885: and ( ( mti.wip_entity_type in (1, 5, 6)
886: and not exists (select 'X'
887: from wip_discrete_jobs wdj
888: where wdj.wip_entity_id = mti.transaction_source_id
889: and wdj.organization_id = mti.organization_id
890: and wdj.status_type in (3,4)))
891: or ( mti.wip_entity_type = 2

Line 924: from wip_discrete_jobs wdj

920: and transaction_action_id in (WIP_CONSTANTS.SCRASSY_ACTION,
921: WIP_CONSTANTS.CPLASSY_ACTION,
922: WIP_CONSTANTS.RETASSY_ACTION)
923: and ( (exists (select 'X'
924: from wip_discrete_jobs wdj
925: where wdj.wip_entity_id = mti.transaction_source_id
926: and wdj.organization_id = mti.organization_id
927: and wdj.primary_item_id is null))
928: or ( upper(nvl(mti.flow_schedule, 'N')) = 'Y'

Line 1206: from wip_discrete_jobs wdj

1202: program_id = fnd_global.conc_program_id,
1203: program_update_date = sysdate,
1204: request_id = fnd_global.conc_request_id,
1205: revision = (select nvl(mti.revision, wdj.bom_revision)
1206: from wip_discrete_jobs wdj
1207: where wdj.organization_id = mti.organization_id
1208: and wdj.wip_entity_id = mti.transaction_source_id)
1209: where transaction_header_id = p_txnHeaderID
1210: and transaction_source_type_id = 5

Line 1518: from wip_discrete_jobs wdj

1514: and transaction_source_type_id = 5
1515: and transaction_action_id = WIP_CONSTANTS.RETASSY_ACTION
1516: and ( wip_entity_type in (1,5)
1517: and (-1*primary_quantity > (select wdj.quantity_completed
1518: from wip_discrete_jobs wdj
1519: where wdj.organization_id = mti.organization_id
1520: and wdj.wip_entity_id = mti.transaction_source_id)));
1521:
1522: -- validate if asset item then cannot complete to expense sub.

Line 1599: from wip_discrete_jobs wdj

1595: and wrs.status_type in (3,4)))
1596: or ( mti.wip_entity_type in (1, 5, 6)
1597: and mti.transaction_date <
1598: (select wdj.date_released
1599: from wip_discrete_jobs wdj
1600: where wdj.wip_entity_id = mti.transaction_source_id
1601: and wdj.organization_id = mti.organization_id
1602: and wdj.status_type in (3, 4))));
1603:

Line 1905: from wip_discrete_jobs wdj,

1901: and wip_entity_type = 1 -- Discrete Jobs
1902: and transaction_source_id is not null
1903: and not exists
1904: (select 'x'
1905: from wip_discrete_jobs wdj,
1906: wip_entities we
1907: where wdj.wip_entity_id = mti.transaction_source_id
1908: and wdj.organization_id = mti.organization_id
1909: and wdj.wip_entity_id = we.wip_entity_id

Line 2571: from wip_discrete_jobs

2567: request_id = fnd_global.conc_request_id,
2568: (source_project_id, source_task_id) =
2569: (select project_id,
2570: task_id
2571: from wip_discrete_jobs
2572: where wip_entity_id = mti.transaction_source_id
2573: and organization_id = mti.organization_id)
2574: where transaction_header_id = p_txnHeaderID
2575: and process_flag = 1