DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on BOM_DEPARTMENTS

Line 3402: FROM bom_departments bd,

3398: NULL, -- po_line_id
3399: NULL, -- repetitive_schedule_id
3400: wdj.project_id,
3401: wdj.task_id
3402: FROM bom_departments bd,
3403: bom_resources br,
3404: cst_activities ca,
3405: wip_operation_resources wor,
3406: wip_discrete_jobs wdj,

Line 3614: FROM bom_departments bd,

3610: MAX(wmti.transaction_id), -- move_transaction_id
3611: NULL, -- po_header_id
3612: NULL, -- po_line_id
3613: NULL -- repetitive_schedule_id
3614: FROM bom_departments bd,
3615: bom_resources br,
3616: cst_activities ca,
3617: wip_operation_resources wor,
3618: wip_move_txn_allocations wma,

Line 3855: FROM bom_departments bd,

3851: NULL, -- po_line_id
3852: NULL, -- repetitive_schedule_id
3853: MAX(wdj.project_id),
3854: MAX(wdj.task_id)
3855: FROM bom_departments bd,
3856: bom_resources br,
3857: cst_activities ca,
3858: wip_operation_resources wor,
3859: wip_discrete_jobs wdj,

Line 4066: FROM bom_departments bd,

4062: MAX(wmti.transaction_id), -- move_transaction_id
4063: NULL, -- po_header_id
4064: NULL, -- po_line_id
4065: wma.repetitive_schedule_id
4066: FROM bom_departments bd,
4067: bom_resources br,
4068: cst_activities ca,
4069: wip_operation_resources wor,
4070: wip_move_txn_allocations wma,

Line 4693: FROM bom_departments bd,

4689: NULL, -- po_line_id
4690: NULL, -- repetitive_schedule_id
4691: MAX(wdj.project_id),
4692: MAX(wdj.task_id)
4693: FROM bom_departments bd,
4694: wip_operations wop,
4695: wip_operation_resources wor,
4696: wip_discrete_jobs wdj,
4697: wip_move_txn_interface wmti,

Line 4915: FROM bom_departments bd,

4911: MAX(wmti.transaction_id), -- move_transaction_id
4912: NULL, -- po_header_id
4913: NULL, -- po_line_id
4914: NULL -- repetitive_schedule_id
4915: FROM bom_departments bd,
4916: wip_move_txn_allocations wma,
4917: wip_operations wop,
4918: wip_move_txn_interface wmti,
4919: wip_operation_resources wor

Line 5152: FROM bom_departments bd,

5148: NULL, -- po_line_id
5149: NULL, -- repetitive_schedule_id
5150: MAX(wdj.project_id),
5151: MAX(wdj.task_id)
5152: FROM bom_departments bd,
5153: wip_operations wop,
5154: wip_operation_resources wor,
5155: wip_discrete_jobs wdj,
5156: wip_move_txn_interface wmti

Line 5367: FROM bom_departments bd,

5363: MAX(wmti.transaction_id), -- move_transaction_id
5364: NULL, -- po_header_id
5365: NULL, -- po_line_id
5366: wma.repetitive_schedule_id
5367: FROM bom_departments bd,
5368: wip_move_txn_allocations wma,
5369: wip_operations wop,
5370: wip_move_txn_interface wmti,
5371: wip_operation_resources wor

Line 5934: bom_departments bd,

5930: bom_calendar_dates bcd4,
5931: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
5932: bom_calendar_dates bcd3,
5933: fnd_user fu,
5934: bom_departments bd,
5935: hr_organization_information hoi,
5936: wip_discrete_jobs wdj,
5937: wip_operations wo1,
5938: wip_operations wo2

Line 6132: bom_departments bd,

6128: 'Y', -- autosource_flag
6129: NULL, -- group_code
6130: msi.buyer_id -- suggested_buyer_id
6131: FROM bom_resources br,
6132: bom_departments bd,
6133: bom_calendar_dates bcd1,
6134: bom_calendar_dates bcd2,
6135: fnd_user fu,
6136: mtl_system_items msi,

Line 6344: bom_departments bd,

6340: bom_calendar_dates bcd4,
6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6342: bom_calendar_dates bcd3,
6343: fnd_user fu,
6344: bom_departments bd,
6345: hr_organization_information hoi,
6346: wip_discrete_jobs wdj,
6347: wip_operations wo1,
6348: wip_operations wo2

Line 6558: FROM bom_departments bd,

6554: MAX(wo2.first_unit_start_date))))), -- need_by_date
6555: 'Y', -- autosource_flag
6556: NULL, -- group_code
6557: MAX(msi.buyer_id) -- suggested_buyer_id
6558: FROM bom_departments bd,
6559: bom_resources br,
6560: bom_calendar_dates bcd1,
6561: bom_calendar_dates bcd2,
6562: fnd_user fu,