DBA Data[Home] [Help]

APPS.RCV_TABLE_FUNCTIONS dependencies on MTL_ITEM_CATEGORIES

Line 18: g_mic_row mtl_item_categories%ROWTYPE;

14: g_oel_row oe_order_lines_all%ROWTYPE;
15: g_prl_row po_requisition_lines_all%ROWTYPE;
16: g_prd_row po_req_distributions_all%ROWTYPE;
17: g_msi_row mtl_system_items%ROWTYPE;
18: g_mic_row mtl_item_categories%ROWTYPE;
19: g_mp_row mtl_parameters%ROWTYPE;
20: g_rp_row rcv_parameters%ROWTYPE;
21: g_fc_row fnd_currencies%ROWTYPE;
22: g_sob_row gl_sets_of_books%ROWTYPE;

Line 977: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE

973: invalid_value('(' || p_item_id || ', ' || p_org_id || ')', '(ITEM_ID,TO_ORGANIZATION_ID)');
974: END get_msi_row_from_num;
975:
976: FUNCTION get_mic_row_from_num
977: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
978: , p_org_id IN mtl_item_categories.organization_id%TYPE
979: )
980: RETURN mtl_item_categories%ROWTYPE IS
981: BEGIN

Line 978: , p_org_id IN mtl_item_categories.organization_id%TYPE

974: END get_msi_row_from_num;
975:
976: FUNCTION get_mic_row_from_num
977: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
978: , p_org_id IN mtl_item_categories.organization_id%TYPE
979: )
980: RETURN mtl_item_categories%ROWTYPE IS
981: BEGIN
982: IF ( p_item_id IS NULL OR p_org_id IS NULL ) THEN

Line 980: RETURN mtl_item_categories%ROWTYPE IS

976: FUNCTION get_mic_row_from_num
977: ( p_item_id IN mtl_item_categories.inventory_item_id%TYPE
978: , p_org_id IN mtl_item_categories.organization_id%TYPE
979: )
980: RETURN mtl_item_categories%ROWTYPE IS
981: BEGIN
982: IF ( p_item_id IS NULL OR p_org_id IS NULL ) THEN
983: RETURN NULL;
984: END IF;

Line 992: FROM mtl_item_categories

988: END IF;
989:
990: SELECT *
991: INTO g_mic_row
992: FROM mtl_item_categories
993: WHERE inventory_item_id = p_item_id
994: AND organization_id = p_org_id;
995:
996: RETURN g_mic_row;