DBA Data[Home] [Help]

APPS.CSTPPCIC dependencies on BOM_RESOURCES

Line 373: from bom_resources

369: into l_valid
370: from dual
371: where p_material in
372: (select resource_id
373: from bom_resources
374: where organization_id = p_to_org_id
375: and cost_element_id = 1
376: and default_basis_type = 1
377: and nvl(disable_date, sysdate+1) > sysdate

Line 396: from bom_resources

392: into l_valid
393: from dual
394: where p_material_overhead in
395: (select resource_id
396: from bom_resources
397: where organization_id = p_to_org_id
398: and cost_element_id = 2
399: and default_basis_type = 1
400: and nvl(disable_date, sysdate+1) > sysdate

Line 417: from bom_resources

413: into l_valid
414: from dual
415: where p_resource in
416: (select resource_id
417: from bom_resources
418: where organization_id = p_to_org_id
419: and cost_element_id = 3
420: and default_basis_type = 1
421: and nvl(disable_date, sysdate+1) > sysdate

Line 439: from bom_resources

435: into l_valid
436: from dual
437: where p_outside_processing in
438: (select resource_id
439: from bom_resources
440: where organization_id = p_to_org_id
441: and cost_element_id = 4
442: and default_basis_type = 1
443: and nvl(disable_date, sysdate+1) > sysdate

Line 460: from bom_resources

456: into l_valid
457: from dual
458: where p_overhead in
459: (select resource_id
460: from bom_resources
461: where organization_id = p_to_org_id
462: and cost_element_id = 5
463: and default_basis_type = 1
464: and nvl(disable_date, sysdate+1) > sysdate