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.FA_LEASE_PVT dependencies on PO_VENDOR_SITES_ALL

Line 237: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,

233: -------------------------------------------
234: -- CHECK FOR CHECK LESSOR SITE
235: -------------------------------------------
236: FUNCTION CHECK_LESSOR_SITE_ID (
237: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
238: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
239: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
240: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER
241: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

Line 238: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,

234: -- CHECK FOR CHECK LESSOR SITE
235: -------------------------------------------
236: FUNCTION CHECK_LESSOR_SITE_ID (
237: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
238: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
239: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
240: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER
241: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
242: ) RETURN BOOLEAN AS

Line 251: ,PO_VENDOR_SITES_ALL PVS

247: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
248: ,PVS.ORG_ID LESSOR_SITE_ORG_ID
249: FROM GL_SETS_OF_BOOKS SOB
250: ,HR_ALL_ORGANIZATION_UNITS HAO
251: ,PO_VENDOR_SITES_ALL PVS
252: ,AP_SYSTEM_PARAMETERS_ALL AP
253: WHERE PVS.VENDOR_ID = P_VENDOR_ID
254: AND PVS.VENDOR_SITE_ID = P_VENDOR_SITE_ID
255: AND PVS.ORG_ID IS NOT NULL

Line 265: ,PO_VENDOR_SITES_ALL PVS

261: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
262: ,PVS.ORG_ID LESSOR_SITE_ORG_ID
263: FROM GL_SETS_OF_BOOKS SOB
264: ,AP_SYSTEM_PARAMETERS_ALL AP
265: ,PO_VENDOR_SITES_ALL PVS
266: WHERE PVS.VENDOR_ID = P_VENDOR_ID
267: AND PVS.VENDOR_SITE_ID = P_VENDOR_SITE_ID
268: AND PVS.ORG_ID IS NULL
269: AND AP.ORG_ID IS NULL

Line 306: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,

302: ------------------------------------------
303: -- CHECK FOR CHECK LESSOR SITE CODE
304: ------------------------------------------
305: FUNCTION CHECK_LESSOR_SITE_CODE (
306: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
307: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
308: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
309: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
310: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE

Line 307: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,

303: -- CHECK FOR CHECK LESSOR SITE CODE
304: ------------------------------------------
305: FUNCTION CHECK_LESSOR_SITE_CODE (
306: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
307: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
308: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
309: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
310: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE
311: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null

Line 308: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,

304: ------------------------------------------
305: FUNCTION CHECK_LESSOR_SITE_CODE (
306: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
307: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
308: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
309: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
310: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE
311: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
312: ) RETURN BOOLEAN AS

Line 309: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,

305: FUNCTION CHECK_LESSOR_SITE_CODE (
306: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
307: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
308: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
309: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
310: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE
311: ,p_log_level_rec IN fa_api_types.log_level_rec_type default null
312: ) RETURN BOOLEAN AS
313:

Line 320: ,PO_VENDOR_SITES_ALL PVS

316: PVS.VENDOR_SITE_ID
317: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
318: FROM GL_SETS_OF_BOOKS SOB
319: ,HR_ALL_ORGANIZATION_UNITS HAO
320: ,PO_VENDOR_SITES_ALL PVS
321: ,AP_SYSTEM_PARAMETERS_ALL AP
322: WHERE PVS.VENDOR_ID = P_VENDOR_ID
323: AND PVS.VENDOR_SITE_CODE = P_VENDOR_SITE_CODE
324: AND PVS.ORG_ID IS NOT NULL

Line 334: ,PO_VENDOR_SITES_ALL PVS

330: SELECT PVS.VENDOR_SITE_ID
331: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
332: FROM GL_SETS_OF_BOOKS SOB
333: ,AP_SYSTEM_PARAMETERS_ALL AP
334: ,PO_VENDOR_SITES_ALL PVS
335: WHERE PVS.VENDOR_ID = P_VENDOR_ID
336: AND PVS.VENDOR_SITE_CODE = P_VENDOR_SITE_CODE
337: AND PVS.ORG_ID IS NULL
338: AND AP.ORG_ID IS NULL

Line 754: PO_VENDOR_SITES_ALL B

750: L_LESSOR_ID,
751: L_LESSOR_SITE_ID,
752: L_LESSOR_SITE_ORG_ID
753: FROM FA_LEASES A,
754: PO_VENDOR_SITES_ALL B
755: WHERE A.LEASE_ID = P_LEASE_ID
756: AND A.LESSOR_SITE_ID = B.VENDOR_SITE_ID;
757:
758: IF P_LESSOR_SITE_ORG_ID = L_LESSOR_SITE_ORG_ID THEN