DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on MTL_ITEM_UOMS_VIEW

Line 760: l_uom_desc mtl_item_uoms_view.description%TYPE;

756: l_source_org_code mtl_organizations.organization_code%TYPE;
757: l_dest_org_code mtl_organizations.organization_code%TYPE;
758: l_dest_source_name jtf_rs_resource_extns.source_name%TYPE;
759: l_src_source_name jtf_rs_resource_extns.source_name%TYPE;
760: l_uom_desc mtl_item_uoms_view.description%TYPE;
761: itemtype varchar2(20);
762:
763:
764: CURSOR c_source_owner_dtls IS

Line 798: SELECT description FROM mtl_item_uoms_view

794: SELECT organization_code FROM mtl_organizations
795: WHERE Organization_id = p_transfer_to_organization;
796:
797: CURSOR c_uom_desc IS
798: SELECT description FROM mtl_item_uoms_view
799: WHERE Organization_id = p_organization_id
800: AND Inventory_item_id = p_inventory_item_id AND uom_code = p_uom;
801:
802: CURSOR l_transaction_header_id_csr IS