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 978: ( p_item_id IN mtl_system_items.inventory_item_id%TYPE

974: invalid_value(p_req_distribution_id, 'REQ_DISTRIBUTION_ID');
975: END;
976:
977: FUNCTION get_msi_row_from_num
978: ( p_item_id IN mtl_system_items.inventory_item_id%TYPE
979: , p_org_id IN mtl_system_items.organization_id%TYPE
980: )
981: RETURN mtl_system_items%ROWTYPE IS
982: BEGIN

Line 979: , p_org_id IN mtl_system_items.organization_id%TYPE

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

Line 981: RETURN mtl_system_items%ROWTYPE IS

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

Line 993: FROM mtl_system_items

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