DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on BOM_DEPARTMENTS

Line 3531: FROM bom_departments bd,

3527: NULL, -- po_line_id
3528: NULL, -- repetitive_schedule_id
3529: wdj.project_id,
3530: wdj.task_id
3531: FROM bom_departments bd,
3532: bom_resources br,
3533: cst_activities ca,
3534: wip_operation_resources wor,
3535: wip_discrete_jobs wdj,

Line 3743: FROM bom_departments bd,

3739: MAX(wmti.transaction_id), -- move_transaction_id
3740: NULL, -- po_header_id
3741: NULL, -- po_line_id
3742: NULL -- repetitive_schedule_id
3743: FROM bom_departments bd,
3744: bom_resources br,
3745: cst_activities ca,
3746: wip_operation_resources wor,
3747: wip_move_txn_allocations wma,

Line 3984: FROM bom_departments bd,

3980: NULL, -- po_line_id
3981: NULL, -- repetitive_schedule_id
3982: MAX(wdj.project_id),
3983: MAX(wdj.task_id)
3984: FROM bom_departments bd,
3985: bom_resources br,
3986: cst_activities ca,
3987: wip_operation_resources wor,
3988: wip_discrete_jobs wdj,

Line 4195: FROM bom_departments bd,

4191: MAX(wmti.transaction_id), -- move_transaction_id
4192: NULL, -- po_header_id
4193: NULL, -- po_line_id
4194: wma.repetitive_schedule_id
4195: FROM bom_departments bd,
4196: bom_resources br,
4197: cst_activities ca,
4198: wip_operation_resources wor,
4199: wip_move_txn_allocations wma,

Line 4822: FROM bom_departments bd,

4818: NULL, -- po_line_id
4819: NULL, -- repetitive_schedule_id
4820: MAX(wdj.project_id),
4821: MAX(wdj.task_id)
4822: FROM bom_departments bd,
4823: wip_operations wop,
4824: wip_operation_resources wor,
4825: wip_discrete_jobs wdj,
4826: wip_move_txn_interface wmti,

Line 5044: FROM bom_departments bd,

5040: MAX(wmti.transaction_id), -- move_transaction_id
5041: NULL, -- po_header_id
5042: NULL, -- po_line_id
5043: NULL -- repetitive_schedule_id
5044: FROM bom_departments bd,
5045: wip_move_txn_allocations wma,
5046: wip_operations wop,
5047: wip_move_txn_interface wmti,
5048: wip_operation_resources wor

Line 5281: FROM bom_departments bd,

5277: NULL, -- po_line_id
5278: NULL, -- repetitive_schedule_id
5279: MAX(wdj.project_id),
5280: MAX(wdj.task_id)
5281: FROM bom_departments bd,
5282: wip_operations wop,
5283: wip_operation_resources wor,
5284: wip_discrete_jobs wdj,
5285: wip_move_txn_interface wmti

Line 5496: FROM bom_departments bd,

5492: MAX(wmti.transaction_id), -- move_transaction_id
5493: NULL, -- po_header_id
5494: NULL, -- po_line_id
5495: wma.repetitive_schedule_id
5496: FROM bom_departments bd,
5497: wip_move_txn_allocations wma,
5498: wip_operations wop,
5499: wip_move_txn_interface wmti,
5500: wip_operation_resources wor

Line 6068: bom_departments bd,

6064: bom_calendar_dates bcd4,
6065: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
6066: bom_calendar_dates bcd3,
6067: fnd_user fu,
6068: bom_departments bd,
6069: hr_organization_information hoi,
6070: wip_discrete_jobs wdj,
6071: wip_operations wo1,
6072: wip_operations wo2,

Line 6273: bom_departments bd,

6269: 'Y', -- autosource_flag
6270: NULL, -- group_code
6271: msi.buyer_id -- suggested_buyer_id
6272: FROM bom_resources br,
6273: bom_departments bd,
6274: bom_calendar_dates bcd1,
6275: bom_calendar_dates bcd2,
6276: fnd_user fu,
6277: mtl_system_items msi,

Line 6492: bom_departments bd,

6488: bom_calendar_dates bcd4,
6489: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6490: bom_calendar_dates bcd3,
6491: fnd_user fu,
6492: bom_departments bd,
6493: hr_organization_information hoi,
6494: wip_discrete_jobs wdj,
6495: wip_operations wo1,
6496: wip_operations wo2,

Line 6713: FROM bom_departments bd,

6709: MAX(wo2.first_unit_start_date)))))), -- need_by_date
6710: 'Y', -- autosource_flag
6711: NULL, -- group_code
6712: MAX(msi.buyer_id) -- suggested_buyer_id
6713: FROM bom_departments bd,
6714: bom_resources br,
6715: bom_calendar_dates bcd1,
6716: bom_calendar_dates bcd2,
6717: fnd_user fu,