APPS.CST_SUBELEMENTS_PVT dependencies on BOM_RESOURCES

Line 366: from bom_resources

362: l_statement := 10;
363: /* Bug 5443502: Added join with cost_element_id */
364: select count(*)
365: into l_exists
366: from bom_resources
367: where resource_code = subelement_rec.resource_code
368: and cost_element_id = subelement_rec.cost_element_id
369: and organization_id = p_to_organization_id;
370:

Line 387: from bom_resources

383:
384: l_statement := 40;
385: select resource_id
386: into l_current_rec.ID
387: from bom_resources
388: where organization_id = p_from_organization_id
389: and resource_code = l_current_rec.code;
390:
391: l_statement := 50;

Line 1103: -- bom_resources

1099:
1100: END LOOP;
1101:
1102: ------------------------------------------------------------------------
1103: -- bom_resources
1104: ------------------------------------------------------------------------
1105:
1106: l_statement := 160;
1107:

Line 1156: FROM bom_resources br

1152: l_expenditure_type,
1153: l_absorption_acct,
1154: l_rate_variance_acct,
1155: l_resource_code
1156: FROM bom_resources br
1157: WHERE br.organization_id = p_from_organization_id
1158: AND br.resource_id = l_source_resource_id;
1159:
1160: -------------------------------------------------------------------------

Line 1393: INSERT INTO bom_resources

1389: END IF; -- Check for non-material subelement
1390:
1391: l_statement := 260;
1392:
1393: INSERT INTO bom_resources
1394: (
1395: resource_id,
1396: resource_code,
1397: organization_id,

Line 1441: bom_resources_s.nextval,

1437: program_update_date,
1438: expenditure_type
1439: )
1440: SELECT
1441: bom_resources_s.nextval,
1442: resource_code,
1443: p_to_organization_id,
1444: SYSDATE,
1445: l_user_id,

Line 1489: FROM bom_resources br

1485: l_prog_app_id,
1486: l_prog_id,
1487: SYSDATE,
1488: l_expenditure_type
1489: FROM bom_resources br
1490: WHERE br.resource_id = l_source_resource_id
1491: AND br.organization_id = p_from_organization_id
1492: AND NOT EXISTS (SELECT 'X'
1493: FROM bom_resources br2

Line 1493: FROM bom_resources br2

1489: FROM bom_resources br
1490: WHERE br.resource_id = l_source_resource_id
1491: AND br.organization_id = p_from_organization_id
1492: AND NOT EXISTS (SELECT 'X'
1493: FROM bom_resources br2
1494: WHERE br2.organization_id = p_to_organization_id
1495: AND br2.resource_code = l_resource_code);
1496:
1497: fnd_file.put_line(fnd_file.log,'counter : ' || to_char(l_counter));

Line 2036: FROM bom_resources br

2032: INTO x_expenditure_type
2033: FROM cst_proj_exp_types_val_v
2034: WHERE cost_element_id =
2035: ( SELECT br.cost_element_id
2036: FROM bom_resources br
2037: WHERE br.resource_id = p_resource_id);
2038:
2039: -------------------------------------------------------------------------
2040: -- Standard check of p_commit

Line 2184: bom_resources br

2180: mp.expense_account
2181: INTO x_absorption_account,
2182: x_rate_variance_account
2183: FROM mtl_parameters mp,
2184: bom_resources br
2185: WHERE mp.organization_id = p_to_organization_id
2186: AND br.resource_id = p_resource_id;
2187:
2188: -------------------------------------------------------------------------

Line 2366: FROM BOM_RESOURCES BR,

2362: SELECT BR.RESOURCE_CODE,
2363: CA.ACTIVITY
2364: INTO l_material_subelement_code,
2365: l_mat_activity
2366: FROM BOM_RESOURCES BR,
2367: CST_ACTIVITIES CA
2368: WHERE BR.RESOURCE_ID = p_material_subelement
2369: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2370: end if;

Line 2378: FROM BOM_RESOURCES BR,

2374: SELECT BR.RESOURCE_CODE,
2375: CA.ACTIVITY
2376: INTO l_moh_subelement_code,
2377: l_moh_activity
2378: FROM BOM_RESOURCES BR,
2379: CST_ACTIVITIES CA
2380: WHERE BR.RESOURCE_ID = p_moh_subelement
2381: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2382: end if;

Line 2390: FROM BOM_RESOURCES BR,

2386: SELECT BR.RESOURCE_CODE,
2387: CA.ACTIVITY
2388: INTO l_resource_subelement_code,
2389: l_res_activity
2390: FROM BOM_RESOURCES BR,
2391: CST_ACTIVITIES CA
2392: WHERE BR.RESOURCE_ID = p_resource_subelement
2393: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2394: end if;

Line 2402: FROM BOM_RESOURCES BR,

2398: SELECT BR.RESOURCE_CODE,
2399: CA.ACTIVITY
2400: INTO l_osp_subelement_code,
2401: l_osp_activity
2402: FROM BOM_RESOURCES BR,
2403: CST_ACTIVITIES CA
2404: WHERE BR.RESOURCE_ID = p_osp_subelement
2405: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2406: end if;

Line 2414: FROM BOM_RESOURCES BR,

2410: SELECT BR.RESOURCE_CODE,
2411: CA.ACTIVITY
2412: INTO l_overhead_subelement_code,
2413: l_ovh_activity
2414: FROM BOM_RESOURCES BR,
2415: CST_ACTIVITIES CA
2416: WHERE BR.RESOURCE_ID = p_overhead_subelement
2417: AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+);
2418: end if;