APPS.PO_NEGOTIATIONS_SV2 dependencies on MTL_SYSTEM_ITEMS

Line 261: from mtl_system_items msi

257: --get from item level for destination org
258: begin
259: select msi.receipt_required_flag
260: into x_receipt_required_flag
261: from mtl_system_items msi
262: where msi.inventory_item_id = x_item_id
263: and msi.organization_id = l_ship_to_organization_id;
264: exception
265: when no_data_found then

Line 275: from mtl_system_items msi

271: if x_receipt_required_flag is null then
272: begin
273: select msi.receipt_required_flag
274: into x_receipt_required_flag
275: from mtl_system_items msi
276: where msi.inventory_item_id = x_item_id
277: and msi.organization_id = x_inventory_organization_id;
278: exception
279: when no_data_found then

Line 998: nvl(fad.column1,'NOVAL') <> 'MTL_SYSTEM_ITEMS'

994: --5938614
995: AND ((X_column1 = 'NEGREQ')
996: or
997: ((X_column1='NEG') and
998: nvl(fad.column1,'NOVAL') <> 'MTL_SYSTEM_ITEMS'
999: ));
1000:
1001: CURSOR shorttext (mid NUMBER) IS
1002: SELECT short_text