APPS.CST_SUBELEMENTS_PVT dependencies on BOM_DEPARTMENTS

Line 410: from bom_departments

406:
407: l_statement := 60;
408: select count(*)
409: into l_exists
410: from bom_departments
411: where department_code = department_rec.department
412: and organization_id = p_to_organization_id;
413:
414: l_statement := 70;

Line 430: from bom_departments

426:
427: l_statement := 90;
428: select department_id
429: into l_current_rec.ID
430: from bom_departments
431: where organization_id = p_from_organization_id
432: and department_code = l_current_rec.code;
433:
434: l_statement := 100;

Line 878: FROM bom_departments bd

874: SELECT scrap_account,
875: est_absorption_account
876: INTO l_scrap_acct,
877: l_est_abs_acct
878: FROM bom_departments bd
879: WHERE bd.department_id = l_source_department_id;
880:
881:
882: END IF; --check for p_exact_copy_flag

Line 916: FROM bom_departments bd

912: SELECT department_class_code,
913: department_code
914: INTO l_department_class_code,
915: l_department_code
916: FROM bom_departments bd
917: WHERE bd.organization_id = p_from_organization_id
918: AND bd.department_id = l_source_department_id;
919:
920: l_statement := 140;

Line 1011: INSERT INTO bom_departments

1007: -- Create the department
1008: -- How do we ensure that location id is valid for to_org?
1009: ----------------------------------------------------------------------
1010:
1011: INSERT INTO bom_departments
1012: (
1013: department_id,
1014: department_code,
1015: organization_id,

Line 1050: bom_departments_s.nextval,

1046: scrap_account,
1047: est_absorption_account
1048: )
1049: SELECT
1050: bom_departments_s.nextval,
1051: department_code,
1052: p_to_organization_id,
1053: SYSDATE,
1054: l_user_id,

Line 1085: FROM bom_departments

1081: location_id,
1082: pa_expenditure_org_id,
1083: decode(l_to_wsm_flag, 1, l_scrap_acct, NULL),
1084: decode(l_to_wsm_flag, 1, l_est_abs_acct, NULL)
1085: FROM bom_departments
1086: WHERE organization_id = p_from_organization_id
1087: AND department_id = l_source_department_id
1088: AND NOT EXISTS (SELECT 'X'
1089: FROM bom_departments bd2

Line 1089: FROM bom_departments bd2

1085: FROM bom_departments
1086: WHERE organization_id = p_from_organization_id
1087: AND department_id = l_source_department_id
1088: AND NOT EXISTS (SELECT 'X'
1089: FROM bom_departments bd2
1090: WHERE bd2.organization_id = p_to_organization_id
1091: AND bd2.department_code = l_department_code);
1092:
1093: IF (SQL%ROWCOUNT) > 0 THEN