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.PO_GA_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 1422: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)

1418: -- The item ID on the GA line
1419: --p_org_id
1420: -- The org ID of the OU to test against p_owning_org_id
1421: --p_ga_item_revision
1422: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)
1423: --p_owning_org_id
1424: -- The GA Owning Org ID
1425: --p_check_rev_control
1426: -- If TRUE, then the revision control property of the item in p_org_id will be

Line 1448: -- (MTL_ITEM_REVISIONS_B.revision%TYPE)

1444: --x_item_revision
1445: -- The valid item revision for the item in p_org_id. This will be NULL if
1446: -- p_ga_item_revision is not available in p_org_id, but revision control for
1447: -- p_item_id in p_org_id is off.
1448: -- (MTL_ITEM_REVISIONS_B.revision%TYPE)
1449: --End of Comments
1450: --------------------------------------------------------------------------------
1451: PROCEDURE validate_item_revision
1452: (

Line 1499: mtl_item_revisions_b mir_ga, -- GA revision

1495: SELECT mir_ga.revision
1496: INTO x_item_revision
1497: FROM financials_system_params_all fspa_ga, -- GA owning org
1498: financials_system_params_all fspa,
1499: mtl_item_revisions_b mir_ga, -- GA revision
1500: mtl_item_revisions_b mir
1501: WHERE fspa_ga.org_id = p_owning_org_id
1502: AND mir_ga.organization_id = fspa_ga.inventory_organization_id
1503: AND mir_ga.inventory_item_id = p_item_id

Line 1500: mtl_item_revisions_b mir

1496: INTO x_item_revision
1497: FROM financials_system_params_all fspa_ga, -- GA owning org
1498: financials_system_params_all fspa,
1499: mtl_item_revisions_b mir_ga, -- GA revision
1500: mtl_item_revisions_b mir
1501: WHERE fspa_ga.org_id = p_owning_org_id
1502: AND mir_ga.organization_id = fspa_ga.inventory_organization_id
1503: AND mir_ga.inventory_item_id = p_item_id
1504: AND mir_ga.revision = p_ga_item_revision

Line 1536: mtl_item_revisions_b mir_ga, -- GA revision

1532: SELECT NVL(msi.revision_qty_control_code, 1)
1533: INTO l_rev_control
1534: FROM financials_system_params_all fspa_ga, -- GA owning org
1535: financials_system_params_all fspa,
1536: mtl_item_revisions_b mir_ga, -- GA revision
1537: mtl_system_items_b msi
1538: WHERE fspa_ga.org_id = p_owning_org_id
1539: AND mir_ga.organization_id = fspa_ga.inventory_organization_id
1540: AND mir_ga.inventory_item_id = p_item_id

Line 1597: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)

1593: -- The type of OU that p_org_id is for the GA. Acceptable values are the
1594: -- global variables g_requesting_org_type or g_purchasing_org_type. Calls
1595: -- APP_EXCEPTION.invalid_argument if the parameter is not one of these values.
1596: --p_ga_item_revision
1597: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)
1598: --p_owning_org_id
1599: -- The GA Owning Org ID
1600: --OUT:
1601: --x_return_status

Line 1622: -- (MTL_ITEM_REVISIONS_B.revision%TYPE)

1618: --
1619: -- FALSE otherwise.
1620: --x_item_revision
1621: -- The valid item revision for the item in p_org_id.
1622: -- (MTL_ITEM_REVISIONS_B.revision%TYPE)
1623: --End of Comments
1624: --------------------------------------------------------------------------------
1625: PROCEDURE validate_item_in_org
1626: (

Line 2007: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)

2003: -- The item ID on the GA line
2004: --p_purchasing_org_id
2005: -- The org ID of the Purchasing Org, or NULL to use the current OU.
2006: --p_ga_item_revision
2007: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)
2008: --p_owning_org_id
2009: -- The GA Owning Org ID
2010: --OUT:
2011: --x_return_status

Line 2024: -- p_purchasing_org_id. (MTL_ITEM_REVISIONS_B.revision%TYPE)

2020: -- Purchasing Org.
2021: -- FALSE otherwise.
2022: --x_item_revision
2023: -- The valid item revision for the item in the Purchasing Org
2024: -- p_purchasing_org_id. (MTL_ITEM_REVISIONS_B.revision%TYPE)
2025: --End of Comments
2026: ---------------------------------------------------------------------------
2027: PROCEDURE validate_in_purchasing_org
2028: (

Line 2043: l_item_revision MTL_ITEM_REVISIONS_B.revision%TYPE;

2039: IS
2040:
2041: l_purchasing_org_id
2042: PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE := p_purchasing_org_id;
2043: l_item_revision MTL_ITEM_REVISIONS_B.revision%TYPE;
2044: l_progress VARCHAR2(3);
2045:
2046: BEGIN
2047: l_progress := '000';

Line 2149: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)

2145: -- The item ID on the GA line
2146: --p_requesting_org_id
2147: -- The org ID of the Requesting Org, or NULL to use the current OU.
2148: --p_ga_item_revision
2149: -- The item revision on the GA line. (MTL_ITEM_REVISIONS_B.revision%TYPE)
2150: --p_owning_org_id
2151: -- The GA Owning Org ID
2152: --OUT:
2153: --x_return_status

Line 2166: -- p_requesting_org_id. (MTL_ITEM_REVISIONS_B.revision%TYPE)

2162: -- Requesting Org.
2163: -- FALSE otherwise.
2164: --x_item_revision
2165: -- The valid item revision for the item in the Requesting Org
2166: -- p_requesting_org_id. (MTL_ITEM_REVISIONS_B.revision%TYPE)
2167: --End of Comments
2168: ---------------------------------------------------------------------------
2169: PROCEDURE validate_in_requesting_org
2170: (

Line 2186: l_dummy_revision MTL_ITEM_REVISIONS_B.revision%TYPE;

2182:
2183: l_requesting_org_id
2184: PO_GA_ORG_ASSIGNMENTS.organization_id%TYPE := p_requesting_org_id;
2185: l_purchasing_org_id PO_GA_ORG_ASSIGNMENTS.purchasing_org_id%TYPE;
2186: l_dummy_revision MTL_ITEM_REVISIONS_B.revision%TYPE;
2187: l_progress VARCHAR2(3);
2188:
2189: BEGIN
2190: l_progress := '000';