APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,

207: TYPE line_record IS RECORD (
208:
209: req_line_id po_requisition_lines.requisition_line_id%TYPE,
210: line_num po_requisition_lines.line_num%TYPE,
211: item_num mtl_system_items_kfv.concatenated_segments%TYPE,
212: item_revision po_requisition_lines.item_revision%TYPE,
213: item_desc po_requisition_lines.item_description%TYPE,
214: uom mtl_units_of_measure.unit_of_measure_tl%TYPE,
215: quantity po_requisition_lines.quantity%TYPE,

Line 678: mtl_system_items_kfv msi,

674: rql.source_type_code,
675: rql.line_location_id,
676: rql.cancel_flag
677: FROM po_requisition_lines rql,
678: mtl_system_items_kfv msi,
679: hr_locations_all hrt,
680: per_all_people_f per,
681: mtl_units_of_measure muom,
682: org_organization_definitions org,

Line 1189: mtl_system_items_kfv msi,

1185: rql.source_type_code,
1186: rql.line_location_id,
1187: rql.cancel_flag
1188: FROM po_requisition_lines rql,
1189: mtl_system_items_kfv msi,
1190: hr_locations_all hrt,
1191: per_all_people_f per,
1192: mtl_units_of_measure muom,
1193: org_organization_definitions org,

Line 2481: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

2477: l_has_temp_labor in boolean,
2478: l_display_type in varchar2,
2479: l_document out NOCOPY varchar2) is
2480:
2481: l_item MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
2482: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2483:
2484: begin
2485:

Line 2508: from mtl_system_items_kfv msi,

2504: -- fix bug 2739962, get the item
2505: begin
2506: select msi.concatenated_segments
2507: into l_item
2508: from mtl_system_items_kfv msi,
2509: financials_system_params_all fsp
2510: where msi.inventory_item_id=l_item_id
2511: and fsp.INVENTORY_ORGANIZATION_ID =
2512: NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)

Line 2637: from mtl_system_items_kfv msi,

2633: -- fix bug 2739962, get the item
2634: begin
2635: select msi.concatenated_segments
2636: into l_item
2637: from mtl_system_items_kfv msi,
2638: financials_system_params_all fsp
2639: where msi.inventory_item_id=l_item_id
2640: and fsp.INVENTORY_ORGANIZATION_ID =
2641: NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)