APPS.RCV_TABLE_FUNCTIONS dependencies on MTL_SYSTEM_ITEMS

Line 17: g_msi_row mtl_system_items%ROWTYPE;

13: g_oeh_row oe_order_headers_all%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;

Line 951: ( p_item_id IN mtl_system_items.inventory_item_id%TYPE

947: invalid_value(p_req_distribution_id, 'REQ_DISTRIBUTION_ID');
948: END;
949:
950: FUNCTION get_msi_row_from_num
951: ( p_item_id IN mtl_system_items.inventory_item_id%TYPE
952: , p_org_id IN mtl_system_items.organization_id%TYPE
953: )
954: RETURN mtl_system_items%ROWTYPE IS
955: BEGIN

Line 952: , p_org_id IN mtl_system_items.organization_id%TYPE

948: END;
949:
950: FUNCTION get_msi_row_from_num
951: ( p_item_id IN mtl_system_items.inventory_item_id%TYPE
952: , p_org_id IN mtl_system_items.organization_id%TYPE
953: )
954: RETURN mtl_system_items%ROWTYPE IS
955: BEGIN
956: IF ( p_item_id IS NULL OR p_org_id IS NULL ) THEN

Line 954: RETURN mtl_system_items%ROWTYPE IS

950: FUNCTION get_msi_row_from_num
951: ( p_item_id IN mtl_system_items.inventory_item_id%TYPE
952: , p_org_id IN mtl_system_items.organization_id%TYPE
953: )
954: RETURN mtl_system_items%ROWTYPE IS
955: BEGIN
956: IF ( p_item_id IS NULL OR p_org_id IS NULL ) THEN
957: RETURN NULL;
958: END IF;

Line 966: FROM mtl_system_items

962: END IF;
963:
964: SELECT *
965: INTO g_msi_row
966: FROM mtl_system_items
967: WHERE inventory_item_id = p_item_id
968: AND organization_id = p_org_id;
969:
970: RETURN g_msi_row;