DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on BOM_RESOURCES

Line 3532: bom_resources br,

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,
3536: wip_operations wop,

Line 3744: bom_resources br,

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,
3748: wip_operations wop,

Line 3985: bom_resources br,

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,
3989: wip_operations wop,

Line 4196: bom_resources br,

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,
4200: wip_operations wop,

Line 6060: bom_resources br,

6056: DECODE(wdj.project_id,NULL,NULL,'Y')-- project_accounting_context
6057: FROM /* bugfix 5129403: modified the order in the from clause */
6058: wip_move_txn_interface wmti,
6059: wip_operation_resources wor,
6060: bom_resources br,
6061: mtl_system_items msi,
6062: mtl_parameters mp,
6063: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
6064: bom_calendar_dates bcd4,

Line 6272: FROM bom_resources br,

6268: wo2.first_unit_start_date))))), -- need_by_date /* Bug 4398047 removed one matching bracket for decode */
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,

Line 6484: bom_resources br,

6480: DECODE(wdj.project_id,NULL,NULL,'Y')-- project_accounting_context
6481: FROM /* bugfix 5129403: modified the order in the from clause */
6482: wip_move_txn_interface wmti,
6483: wip_operation_resources wor,
6484: bom_resources br,
6485: mtl_system_items msi,
6486: mtl_parameters mp,
6487: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6488: bom_calendar_dates bcd4,

Line 6714: bom_resources br,

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,
6718: mtl_item_revisions mir,

Line 6907: FROM bom_resources br,

6903: wmti.primary_quantity pri_qty,
6904: muom.unit_of_measure pri_uom,
6905: wmti.to_operation_seq_num op_seq_num,
6906: wor.autocharge_type autocharge_type
6907: FROM bom_resources br,
6908: mtl_units_of_measure muom,
6909: wip_operation_resources wor,
6910: wip_operations wo,
6911: wip_move_txn_interface wmti