DBA Data[Home] [Help]

APPS.BOM_OPERATION_PVT dependencies on BOM_DEPARTMENTS

Line 46: from bom_departments

42: From mtl_parameters
43: Where organization_code = P_Code;
44: cursor l_department_csr(P_code varchar2, P_OrgId number) is
45: select department_id
46: from bom_departments
47: where organization_id = P_OrgId
48: and department_code = P_Code;
49: cursor l_routing_csr(P_AssyItemId number, P_OrgId number,
50: P_Alternate varchar2) is

Line 393: from bom_departments bd,

389: select 'x' dummy
390: from dual
391: where not exists(
392: Select null
393: from bom_departments bd,
394: bom_operational_routings bor
395: where bd.organization_id = bor.organization_id
396: and bor.routing_sequence_id = P_RtgSeqId
397: and bd.department_id = P_DeptId