DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on BOM_SUB_OPERATION_RESOURCES

Line 485: bom_sub_operation_resources bsor

481: lv_alt_schd_seq_num
482: From WSM_LOT_JOB_DTL_INTERFACE jdi,
483: bom_operation_resources bor,
484: bom_operation_sequences bos,
485: bom_sub_operation_resources bsor
486: Where jdi.group_id = G_WIP_GROUP_ID
487: and jdi.parent_header_id = lv_header_id(n)
488: -- and jdi.load_type in (1,4)
489: and jdi.load_type in (1,4, RESOURCE_INSTANCES_OSFM, RESOURCE_INSTANCE_USAGE_OSFM)

Line 586: from bom_sub_operation_resources bsor,

582: , jdi.group_sequence_num --- sbala
583: , jdi.batch_id
584: , jdi.max_assigned_units --- sbala
585: , jdi.parent_resource_seq_num
586: from bom_sub_operation_resources bsor,
587: bom_operation_sequences bos,
588: wsm_lot_job_dtl_interface jdi
589: Where bsor.schedule_flag = 2
590: and bsor.schedule_seq_num = jdi.schedule_seq_num

Line 3413: FROM BOM_SUB_OPERATION_RESOURCES bor,

3409: , lsud_batch_id
3410: , lsud_maximum_assigned_units
3411: , lsud_parent_seq_num
3412: -- , lsud_schedule_seq_num
3413: FROM BOM_SUB_OPERATION_RESOURCES bor,
3414: bom_operation_resources bor1,
3415: BOM_OPERATION_SEQUENCES os,
3416: BOM_RESOURCES br,
3417: WIP_JOB_DTLS_INTERFACE JDI