DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_SV dependencies on BOM_DEPARTMENTS

Line 869: bom_departments bd,

865: INTO X_job,
866: X_sequence,
867: X_department
868: FROM wip_entities we,
869: bom_departments bd,
870: wip_operation_resources wr,
871: wip_operations wn,
872: wip_operations wo
873: WHERE wo.wip_entity_id = X_wip_entity_id

Line 915: FROM bom_departments bd,

911: begin
912: SELECT wn.operation_seq_num sequence,
913: bd.department_code department
914: INTO X_sequence, X_department
915: FROM bom_departments bd,
916: wip_operation_resources wr,
917: wip_operations wn,
918: wip_operations wo
919: WHERE wo.wip_entity_id = X_wip_entity_id

Line 950: from bom_departments bd,wip_operations wn

946: --find department code and sequence with out touching resource table.
947: begin
948: select bd.department_code department
949: into X_department
950: from bom_departments bd,wip_operations wn
951: where wn.wip_entity_id = X_wip_entity_id
952: and wn.organization_id = X_to_organization_id
953: and nvl(wn.repetitive_schedule_id, -1) =
954: nvl(X_wip_repetitive_schedule_id, -1)