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.OM_SETUP_VALID_PKG dependencies on OE_TRANSACTION_TYPES_ALL

Line 1975: FROM OE_TRANSACTION_TYPES_ALL T

1971: cnt3 NUMBER := 1;
1972: /* Cursor Variables */
1973: CURSOR csr2 IS
1974: SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID
1975: FROM OE_TRANSACTION_TYPES_ALL T
1976: WHERE NOT T.TRANSACTION_TYPE_ID IN ( SELECT UNIQUE ORDER_TYPE_ID
1977: FROM OE_WORKFLOW_ASSIGNMENTS
1978: WHERE LINE_TYPE_ID IS NULL );
1979: csrvar2 csr2%ROWTYPE;

Line 1982: FROM OE_TRANSACTION_TYPES_ALL T

1978: WHERE LINE_TYPE_ID IS NULL );
1979: csrvar2 csr2%ROWTYPE;
1980: CURSOR csr3 IS
1981: SELECT T.TRANSACTION_TYPE_ID, T.ORG_ID
1982: FROM OE_TRANSACTION_TYPES_ALL T
1983: WHERE NOT T.TRANSACTION_TYPE_ID IN ( SELECT UNIQUE ORDER_TYPE_ID
1984: FROM OE_WORKFLOW_ASSIGNMENTS
1985: WHERE LINE_TYPE_ID IS NOT NULL );
1986: csrvar3 csr3%ROWTYPE;

Line 1989: FROM OE_TRANSACTION_TYPES_ALL

1985: WHERE LINE_TYPE_ID IS NOT NULL );
1986: csrvar3 csr3%ROWTYPE;
1987: CURSOR csr4 IS
1988: SELECT TRANSACTION_TYPE_ID, ORG_ID
1989: FROM OE_TRANSACTION_TYPES_ALL
1990: WHERE TRANSACTION_TYPE_CODE = 'ORDER'
1991: AND ORDER_CATEGORY_CODE <> 'RETURN'
1992: AND DEFAULT_OUTBOUND_LINE_TYPE_ID IS NULL;
1993:

Line 1997: FROM OE_TRANSACTION_TYPES_ALL

1993:
1994: csrvar4 csr4%ROWTYPE;
1995: CURSOR csr5 IS
1996: SELECT TRANSACTION_TYPE_ID, ORG_ID
1997: FROM OE_TRANSACTION_TYPES_ALL
1998: WHERE TRANSACTION_TYPE_CODE = 'ORDER'
1999: AND DEFAULT_INBOUND_LINE_TYPE_ID IS NULL
2000: AND ORDER_CATEGORY_CODE <> 'ORDER';
2001: csrvar5 csr5%ROWTYPE;

Line 2004: FROM OE_TRANSACTION_TYPES_ALL

2000: AND ORDER_CATEGORY_CODE <> 'ORDER';
2001: csrvar5 csr5%ROWTYPE;
2002: CURSOR csr6 IS
2003: SELECT TRANSACTION_TYPE_ID, ORG_ID
2004: FROM OE_TRANSACTION_TYPES_ALL
2005: WHERE ENTRY_CREDIT_CHECK_RULE_ID IS NULL
2006: AND SHIPPING_CREDIT_CHECK_RULE_ID IS NULL;
2007: csrvar6 csr6%ROWTYPE;
2008: CURSOR csr7 IS

Line 2010: FROM OE_TRANSACTION_TYPES_ALL

2006: AND SHIPPING_CREDIT_CHECK_RULE_ID IS NULL;
2007: csrvar6 csr6%ROWTYPE;
2008: CURSOR csr7 IS
2009: SELECT TRANSACTION_TYPE_ID, ORG_ID
2010: FROM OE_TRANSACTION_TYPES_ALL
2011: WHERE SCHEDULING_LEVEL_CODE IS NULL;
2012: csrvar7 csr6%ROWTYPE;
2013: CURSOR csr8 IS
2014: SELECT TRANSACTION_TYPE_ID, ORG_ID

Line 2015: FROM OE_TRANSACTION_TYPES_ALL

2011: WHERE SCHEDULING_LEVEL_CODE IS NULL;
2012: csrvar7 csr6%ROWTYPE;
2013: CURSOR csr8 IS
2014: SELECT TRANSACTION_TYPE_ID, ORG_ID
2015: FROM OE_TRANSACTION_TYPES_ALL
2016: WHERE COST_OF_GOODS_SOLD_ACCOUNT IS NULL;
2017: csrvar8 csr8%ROWTYPE;
2018: CURSOR csr9 IS
2019: SELECT TRANSACTION_TYPE_ID, ORG_ID

Line 2020: FROM OE_TRANSACTION_TYPES_ALL

2016: WHERE COST_OF_GOODS_SOLD_ACCOUNT IS NULL;
2017: csrvar8 csr8%ROWTYPE;
2018: CURSOR csr9 IS
2019: SELECT TRANSACTION_TYPE_ID, ORG_ID
2020: FROM OE_TRANSACTION_TYPES_ALL
2021: WHERE NON_DELIVERY_INVOICE_SOURCE_ID IS NULL
2022: AND INVOICE_SOURCE_ID IS NULL;
2023: csrvar9 csr9%ROWTYPE;
2024: CURSOR csr10 IS

Line 2026: FROM OE_TRANSACTION_TYPES_ALL

2022: AND INVOICE_SOURCE_ID IS NULL;
2023: csrvar9 csr9%ROWTYPE;
2024: CURSOR csr10 IS
2025: SELECT UNIQUE ORG_ID
2026: FROM OE_TRANSACTION_TYPES_ALL
2027: WHERE CUST_TRX_TYPE_ID IS NULL;
2028: csrvar10 csr10%ROWTYPE;
2029: BEGIN
2030: IF ( P_LEVEL = 'OU' ) THEN

Line 2049: FROM OE_TRANSACTION_TYPES_ALL

2045: FOR i IN 1..oulist.COUNT
2046: LOOP
2047: SELECT COUNT(TRANSACTION_TYPE_ID)
2048: INTO cnt1
2049: FROM OE_TRANSACTION_TYPES_ALL
2050: WHERE ORG_ID = oulist(i);
2051: IF ( cnt1 = 0 ) THEN
2052: error_type := 'ERROR';
2053: mesg_name := 'ONT_SETVAL_INVALID_TRAN_TYPE_1';

Line 2213: FROM OE_TRANSACTION_TYPES_TL tl, OE_TRANSACTION_TYPES_ALL b

2209: sobhr NUMBER;
2210: /* Cursor Variables */
2211: CURSOR ttypes IS
2212: SELECT tl.NAME, b.ORG_ID
2213: FROM OE_TRANSACTION_TYPES_TL tl, OE_TRANSACTION_TYPES_ALL b
2214: WHERE tl.TRANSACTION_TYPE_ID = b.TRANSACTION_TYPE_ID
2215: AND tl.LANGUAGE=USERENV('LANG')
2216: ORDER BY b.ORG_ID;
2217: ttype ttypes%ROWTYPE;

Line 2221: , OE_TRANSACTION_TYPES_ALL tta

2217: ttype ttypes%ROWTYPE;
2218: CURSOR doccats IS
2219: SELECT tta.ORG_ID, fdsc.CODE, fdsc.NAME
2220: FROM FND_DOC_SEQUENCE_CATEGORIES fdsc
2221: , OE_TRANSACTION_TYPES_ALL tta
2222: , OE_TRANSACTION_TYPES_TL ttl
2223: WHERE ttl.NAME = fdsc.NAME
2224: AND tta.TRANSACTION_TYPE_ID = ttl.TRANSACTION_TYPE_ID
2225: AND ttl.LANGUAGE=USERENV('LANG')

Line 2264: AND TABLE_NAME = 'OE_TRANSACTION_TYPES_ALL';

2260: SELECT COUNT(NAME)
2261: INTO dscatcnt
2262: FROM FND_DOC_SEQUENCE_CATEGORIES
2263: WHERE NAME = ttype.NAME
2264: AND TABLE_NAME = 'OE_TRANSACTION_TYPES_ALL';
2265: IF dscatcnt = 0 THEN
2266: error_type := 'ERROR';
2267: mesg_name := 'ONT_SETVAL_NOTFOUND_DOC_CAT';
2268: errLogged := writeError( entity, p_level, p_value, error_type,

Line 2362: FROM OE_TRANSACTION_TYPES_ALL b

2358: sob VARCHAR2(50);
2359: /* Cursor Variables */
2360: CURSOR ttdisabled IS
2361: SELECT tl.NAME, b.ORG_ID
2362: FROM OE_TRANSACTION_TYPES_ALL b
2363: , OE_TRANSACTION_TYPES_TL tl
2364: WHERE ENTRY_CREDIT_CHECK_RULE_ID IS NULL
2365: AND SHIPPING_CREDIT_CHECK_RULE_ID IS NULL
2366: AND PICKING_CREDIT_CHECK_RULE_ID IS NULL