DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_SV dependencies on BOM_DEPARTMENTS

Line 865: bom_departments bd,

861: INTO X_job,
862: X_sequence,
863: X_department
864: FROM wip_entities we,
865: bom_departments bd,
866: wip_operation_resources wr,
867: wip_operations wn,
868: wip_operations wo
869: WHERE wo.wip_entity_id = X_wip_entity_id

Line 911: FROM bom_departments bd,

907: begin
908: SELECT wn.operation_seq_num sequence,
909: bd.department_code department
910: INTO X_sequence, X_department
911: FROM bom_departments bd,
912: wip_operation_resources wr,
913: wip_operations wn,
914: wip_operations wo
915: WHERE wo.wip_entity_id = X_wip_entity_id

Line 946: from bom_departments bd,wip_operations wn

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