APPS.PO_VAL_LINES2 dependencies on MTL_SYSTEM_ITEMS_VL

Line 4244: select_comb_from_view => 'MTL_SYSTEM_ITEMS_VL',

4240: concat_segments => p_item,
4241: resp_appl_id => x_resp_appl_id,
4242: resp_id => x_resp_id,
4243: user_id => x_user_id,
4244: select_comb_from_view => 'MTL_SYSTEM_ITEMS_VL',
4245: where_clause_msg => 'APPL=PO;NAME=PO_RI_INVALID_ITEM_ID') ;
4246: END IF;
4247:
4248: IF (validateSegments) THEN

Line 4286: x_item mtl_system_items_vl.Concatenated_Segments%type;

4282: x_resp_id NUMBER;
4283: x_resp_appl_id NUMBER;
4284: x_user_id NUMBER;
4285: x_org_id NUMBER;
4286: x_item mtl_system_items_vl.Concatenated_Segments%type;
4287:
4288: BEGIN
4289:
4290: IF PO_LOG.d_proc THEN

Line 4348: select_comb_from_view=>'MTL_SYSTEM_ITEMS_VL'

4344: GET_COLUMNS=>NULL,
4345: RESP_APPL_ID=>x_resp_appl_id,
4346: RESP_ID=>x_resp_id,
4347: USER_ID=>x_user_id,
4348: select_comb_from_view=>'MTL_SYSTEM_ITEMS_VL'
4349: );
4350:
4351: -- Valid item should pass through
4352: -- both validate_ccid and validate_segs

Line 4357: From mtl_system_items_vl msi

4353: IF (v_item) THEN
4354:
4355: Select msi.Concatenated_Segments
4356: into x_item
4357: From mtl_system_items_vl msi
4358: where msi.inventory_item_id = p_item_id_tbl(i)
4359: AND MSI.ORGANIZATION_ID=x_org_id;
4360:
4361: v_item := fnd_flex_keyval.validate_segs(operation => 'CHECK_SEGMENTS',

Line 4369: select_comb_from_view => 'MTL_SYSTEM_ITEMS_VL',

4365: concat_segments => x_item,
4366: resp_appl_id => x_resp_appl_id,
4367: resp_id => x_resp_id,
4368: user_id => x_user_id,
4369: select_comb_from_view => 'MTL_SYSTEM_ITEMS_VL',
4370: where_clause_msg => 'APPL=PO;NAME=PO_RI_INVALID_ITEM_ID') ;
4371: END IF;
4372: END IF;
4373: IF NOT (v_item) THEN