DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PA_RESOURCE_CLASSES_B

Line 377: ,pa_resource_classes_b rc

373: ,x_rev_categ_code
374: FROM
375: PA_RBS_ELEMENTS rbs
376: ,pa_event_types et
377: ,pa_resource_classes_b rc
378: ,pa_expenditure_types expt
379: --,PA_RBS_ELEMENT_NAMES_B rbsn
380: WHERE 1=1
381: AND rbs.rbs_element_id = p_rbs_element_id

Line 438: pa_resource_classes_b cls

434: --collect all inv_item_id that match the retrieved item_category_id
435: SELECT cat.inventory_item_id
436: BULK COLLECT INTO inv_item_id_list
437: FROM
438: pa_resource_classes_b cls
439: , pa_plan_res_defaults def
440: , mtl_item_categories cat
441: WHERE 1=1
442: AND cls.resource_class_id = def.object_id