DBA Data[Home] [Help]

APPS.GMF_COPY_ITEM_COST dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 174: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,

170: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
172: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
173: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
174: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
175: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
176: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
177: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
178: pi_incr_pct IN VARCHAR2,

Line 175: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,

171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
172: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
173: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
174: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
175: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
176: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
177: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
178: pi_incr_pct IN VARCHAR2,
179: pi_incr_decr_cost IN VARCHAR2,

Line 1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,

1955: IS
1956:
1957: TYPE rectype_brdn_dtl IS RECORD(
1958: inventory_item_id cm_brdn_dtl.inventory_item_id%TYPE,
1959: -- item_no mtl_system_items_b_kfv.concatenated_segments%TYPE,
1960: resources cm_brdn_dtl.resources%TYPE,
1961: cost_cmpntcls_id cm_brdn_dtl.cost_cmpntcls_id%TYPE,
1962: cost_analysis_code cm_brdn_dtl.cost_analysis_code%TYPE,
1963: burden_qty cm_brdn_dtl.burden_qty%TYPE,

Line 2527: ' mtl_system_items_b_kfv itm ' ||

2523: l_sub_qry_b :=
2524: ' SELECT ' ||
2525: ' itm.inventory_item_id ' ||
2526: ' FROM ' ||
2527: ' mtl_system_items_b_kfv itm ' ||
2528: ' WHERE ' ||
2529: ' 1 = 1';
2530: IF ( pi_range_type = G_ITEM ) THEN
2531: l_sub_qry_b := l_sub_qry_b ||