eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on MTL_ORGANIZATIONS

Line 625: -- Use ORG_ORGANIZATION_DEFINITIONS instead of mtl_organizations to validate the inventory org

621: -- Fixed the datatype of l_temp_org_name
622: -- SECHAWLA 16-JAN-02 Bug # 2754280
623: -- Changed the call to fn get_user_profile_option_name to refer it from am util
624: -- SECHAWLA 08-MAR-04 Bug # 3492490
625: -- Use ORG_ORGANIZATION_DEFINITIONS instead of mtl_organizations to validate the inventory org
626: -- Validate subinventory is defined for Master org when the remarketing inv org is a child org
627: -- SECHAWLA 19-MAY-04 Bug # 3634514
628: -- Populate subinventory fields on the item master only if 1) the remarketing org is a master org OR
629: -- 2) Remarketing org is a child org and the item is being assigned to the child org

Line 653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For

649: -- This cursor is used to validate an organization Id against mtl_organization
650: CURSOR l_mtlorgcsr(p_org_id NUMBER) IS
651: SELECT organization_name
652: -- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
655: --FROM mtl_organizations
656: FROM ORG_ORGANIZATION_DEFINITIONS
657: WHERE organization_id = p_org_id;

Line 654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs

650: CURSOR l_mtlorgcsr(p_org_id NUMBER) IS
651: SELECT organization_name
652: -- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
655: --FROM mtl_organizations
656: FROM ORG_ORGANIZATION_DEFINITIONS
657: WHERE organization_id = p_org_id;
658:

Line 655: --FROM mtl_organizations

651: SELECT organization_name
652: -- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
655: --FROM mtl_organizations
656: FROM ORG_ORGANIZATION_DEFINITIONS
657: WHERE organization_id = p_org_id;
658:
659: -- This cursor is used to validate Organization and subinventory

Line 721: l_temp_org_name mtl_organizations.organization_name%TYPE;

717: l_temp VARCHAR2(25);
718: -- l_pricelist_exists VARCHAR2(1); -- SECHAWLA 08-DEC-04 4047159
719: l_pricelist_name QP_LIST_HEADERS.name%TYPE; -- SECHAWLA 08-DEC-04 4047159
720: --SECHAWLA 2706328 : Fixed the datatype for l_temp_org_name
721: l_temp_org_name mtl_organizations.organization_name%TYPE;
722: l_temp_ccid VARCHAR2(1);
723: l_count NUMBER;
724: l_default_order_type_id NUMBER;
725:

Line 2046: l_temp_org_name mtl_organizations.organization_name%TYPE;

2042: l_subinv_code VARCHAR2(10);
2043: -- SECHAWLA Bug # 2620853 : Distribution account id is not required
2044: -- l_distribution_account_id NUMBER;
2045: --SECHAWLA 2706328 : Fixed the datatype for l_temp_org_name
2046: l_temp_org_name mtl_organizations.organization_name%TYPE;
2047:
2048: l_header_id NUMBER;
2049: l_inventory_item_id NUMBER;
2050: l_ordered_quantity NUMBER;