[Home] [Help]
650: msi.concatenated_segments,
651: msi.description,
652: occ.external_code
653: FROM mtl_system_items_kfv msi,
654: financials_system_params_all fspa,
655: ozf_supp_code_conversions_all occ
656: WHERE occ.internal_code = to_char(msi.inventory_item_id)
657: AND occ.code_conversion_type = 'OZF_PRODUCT_CODES'
658: AND occ.supp_trade_profile_id = p_supp_trade_profile_id
676: msi.concatenated_segments,
677: msi.description,
678: null external_code
679: FROM mtl_system_items_kfv msi,
680: financials_system_params_all fspa
681: WHERE msi.purchasing_item_flag = 'Y'
682: AND msi.shippable_item_flag = 'Y'
683: AND msi.enabled_flag = 'Y'
684: AND NVL(msi.consigned_flag,2) = 2 -- 2=unconsigned
706: msi.concatenated_segments,
707: msi.description,
708: NULL external_code
709: FROM mtl_system_items_kfv msi,
710: financials_system_params_all fspa
711: WHERE msi.organization_id = fspa.inventory_organization_id
712: AND msi.purchasing_item_flag = 'Y'
713: AND msi.shippable_item_flag = 'Y'
714: AND msi.enabled_flag = 'Y'
864: msi.description
865: FROM
866: mtl_system_items_kfv msi,
867: mtl_parameters mp,
868: financials_system_params_all fspa,
869: oe_order_lines_all oola,
870: dpp_transaction_lines_all dtla
871: WHERE
872: dtla.transaction_header_id = TO_NUMBER(p_search_text1) and
1860: SELECT
1861: msi.LIST_PRICE_PER_UNIT list_price
1862: FROM
1863: mtl_system_items msi,
1864: financials_system_params_all fspa
1865: WHERE
1866: msi.organization_id = fspa.inventory_organization_id and
1867: fspa.org_id = p_organization_id and
1868: msi.inventory_item_id = p_inventory_item_id;
2284: IS
2285: SELECT concatenated_segments,
2286: description
2287: FROM mtl_system_items_kfv msi,
2288: financials_system_params_all fspa
2289: WHERE fspa.org_id = p_org_id and
2290: fspa.inventory_organization_id = msi.organization_id and
2291: msi.inventory_item_id = p_inventory_item_id;
2292: