DBA Data[Home] [Help]

APPS.RCV_CORE_S dependencies on BOM_DEPARTMENTS

Line 1003: bom_departments bd,

999: into x_job_schedule_dsp,
1000: x_op_seq_num_dsp,
1001: x_department_code
1002: from wip_entities we,
1003: bom_departments bd,
1004: wip_operation_resources wr,
1005: wip_operations wn,
1006: wip_operations wo
1007: where wo.wip_entity_id = x_wip_entity_id

Line 1049: FROM bom_departments bd,

1045: SELECT wn.operation_seq_num SEQUENCE,
1046: bd.department_code department
1047: INTO x_op_seq_num_dsp,
1048: x_department_code
1049: FROM bom_departments bd,
1050: wip_operation_resources wr,
1051: wip_operations wn,
1052: wip_operations wo
1053: WHERE wo.wip_entity_id = x_wip_entity_id

Line 1077: FROM bom_departments bd,

1073: --find department code and sequence with out touching resource table.
1074: BEGIN
1075: SELECT bd.department_code department
1076: INTO x_department_code
1077: FROM bom_departments bd,
1078: wip_operations wn
1079: WHERE wn.wip_entity_id = x_wip_entity_id
1080: AND wn.organization_id = x_organization_id
1081: AND NVL(wn.repetitive_schedule_id, -1) = NVL(x_wip_repetitive_schedule_id, -1)