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.ZX_TRX_DETAIL dependencies on ZX_TRANSACTION

Line 281: FROM zx_transaction_lines

277: l_tax_event_type_code VARCHAR2(30);
278:
279: CURSOR C IS
280: SELECT rowid
281: FROM zx_transaction_lines
282: WHERE APPLICATION_ID = p_application_id
283: AND ENTITY_CODE = p_entity_code
284: AND EVENT_CLASS_CODE = p_event_class_code
285: AND TRX_ID = p_trx_id

Line 299: 'Insert into ZX_TRANSACTION_LINES (+)');

295: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Row.BEGIN',
296: 'ZX_TRX_DETAIL: Insert_Row (+)');
297: FND_LOG.STRING(g_level_procedure,
298: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Row',
299: 'Insert into ZX_TRANSACTION_LINES (+)');
300: END IF;
301:
302: --IF p_trx_line_number IS NOT NULL THEN
303: /*

Line 304: UPDATE ZX_TRANSACTION

300: END IF;
301:
302: --IF p_trx_line_number IS NOT NULL THEN
303: /*
304: UPDATE ZX_TRANSACTION
305: SET EVENT_TYPE_CODE = p_event_type_code
306: WHERE APPLICATION_ID = p_application_id
307: AND ENTITY_CODE = p_entity_code
308: AND EVENT_CLASS_CODE = p_event_class_code

Line 311: INSERT INTO ZX_TRANSACTION_LINES (--SUBSCRIBER_ID,

307: AND ENTITY_CODE = p_entity_code
308: AND EVENT_CLASS_CODE = p_event_class_code
309: AND TRX_ID = p_trx_id;
310: */
311: INSERT INTO ZX_TRANSACTION_LINES (--SUBSCRIBER_ID,
312: --INTERNAL_ORGANIZATION_ID,
313: APPLICATION_ID,
314: ENTITY_CODE,
315: EVENT_CLASS_CODE,

Line 561: 'Insert into ZX_TRANSACTION_LINES (-)');

557:
558: IF (g_level_procedure >= g_current_runtime_level ) THEN
559: FND_LOG.STRING(g_level_procedure,
560: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Row',
561: 'Insert into ZX_TRANSACTION_LINES (-)');
562: FND_LOG.STRING(g_level_procedure,
563: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Row.END',
564: 'ZX_TRX_DETAIL: Insert_Row (-)');
565: END IF;

Line 824: 'Update ZX_TRANSACTION_LINES (+)');

820: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Row.BEGIN',
821: 'ZX_TRX_DETAIL: Update_Row (+)');
822: FND_LOG.STRING(g_level_procedure,
823: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Row',
824: 'Update ZX_TRANSACTION_LINES (+)');
825: END IF;
826:
827:
828: UPDATE ZX_TRANSACTION_LINES

Line 828: UPDATE ZX_TRANSACTION_LINES

824: 'Update ZX_TRANSACTION_LINES (+)');
825: END IF;
826:
827:
828: UPDATE ZX_TRANSACTION_LINES
829: SET TRX_LINE_DESCRIPTION = p_trx_line_description,
830: TRX_LINE_TYPE = p_trx_line_type,
831: PRODUCT_ID = p_product_id,
832: PRODUCT_ORG_ID = p_product_org_id,

Line 937: 'Update ZX_TRANSACTION_LINES (-)');

933:
934: IF (g_level_procedure >= g_current_runtime_level ) THEN
935: FND_LOG.STRING(g_level_procedure,
936: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Row',
937: 'Update ZX_TRANSACTION_LINES (-)');
938: FND_LOG.STRING(g_level_procedure,
939: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Row.END',
940: 'ZX_TRX_DETAIL: Update_Row (-)');
941: END IF;

Line 975: 'Deleting ZX_TRANSACTION_LINES');

971:
972: IF (g_level_procedure >= g_current_runtime_level ) THEN
973: FND_LOG.STRING(g_level_procedure,
974: 'ZX.PLSQL.ZX_TRX_DETAIL.Delete_Row',
975: 'Deleting ZX_TRANSACTION_LINES');
976: END IF;
977:
978: DELETE ZX_TRANSACTION_LINES
979: WHERE APPLICATION_ID = p_application_id

Line 978: DELETE ZX_TRANSACTION_LINES

974: 'ZX.PLSQL.ZX_TRX_DETAIL.Delete_Row',
975: 'Deleting ZX_TRANSACTION_LINES');
976: END IF;
977:
978: DELETE ZX_TRANSACTION_LINES
979: WHERE APPLICATION_ID = p_application_id
980: AND ENTITY_CODE = p_entity_code
981: AND EVENT_CLASS_CODE = p_event_class_code
982: AND TRX_ID = p_trx_id

Line 989: 'Deleted ZX_TRANSACTION_LINES');

985:
986: IF (g_level_procedure >= g_current_runtime_level ) THEN
987: FND_LOG.STRING(g_level_procedure,
988: 'ZX.PLSQL.ZX_TRX_DETAIL.Delete_Row',
989: 'Deleted ZX_TRANSACTION_LINES');
990: FND_LOG.STRING(g_level_procedure,
991: 'ZX.PLSQL.ZX_TRX_DETAIL.Delete_Row',
992: 'Calling ZX_API_PUB.Mark_tax_lines_deleted');
993: END IF;

Line 1374: FROM ZX_TRANSACTION_LINES

1370: CREATION_DATE,
1371: LAST_UPDATED_BY,
1372: LAST_UPDATE_DATE,
1373: LAST_UPDATE_LOGIN
1374: FROM ZX_TRANSACTION_LINES
1375: WHERE APPLICATION_ID = p_application_id
1376: AND ENTITY_CODE = p_entity_code
1377: AND EVENT_CLASS_CODE = p_event_class_code
1378: AND TRX_LINE_ID = p_trx_line_id

Line 1786: FROM ZX_TRANSACTION_LINES

1782: NULL MERCHANT_PARTY_REFERENCE,
1783: NULL MERCHANT_PARTY_TAXPAYER_ID,
1784: NULL MERCHANT_PARTY_TAX_REG_NUMBER,
1785: NULL ASSET_NUMBER
1786: FROM ZX_TRANSACTION_LINES
1787: WHERE APPLICATION_ID = p_application_id
1788: AND ENTITY_CODE = p_entity_code
1789: AND EVENT_CLASS_CODE = p_event_class_code
1790: AND TRX_ID = p_trx_id

Line 1985: FROM ZX_TRANSACTION

1981: --p_rdng_ship_to_pty_tx_p_st_id,
1982: --p_rdng_ship_fr_pty_tx_p_st_id, --reduced size p_rdng_ship_from_pty_tx_p_st_id
1983: --p_rdng_bill_to_pty_tx_p_st_id,
1984: --p_rdng_bill_fr_pty_tx_p_st_id); --reduced size p_rdng_bill_from_pty_tx_p_st_id
1985: FROM ZX_TRANSACTION
1986: WHERE APPLICATION_ID = p_application_id
1987: AND ENTITY_CODE = p_entity_code
1988: AND EVENT_CLASS_CODE = p_event_class_code
1989: AND TRX_ID = p_trx_id;

Line 2000: 'Insert into ZX_TRANSACTION_LINES_GT (+)');

1996:
1997: IF (g_level_procedure >= g_current_runtime_level ) THEN
1998: FND_LOG.STRING(g_level_procedure,
1999: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Temporary_Table',
2000: 'Insert into ZX_TRANSACTION_LINES_GT (+)');
2001: END IF;
2002:
2003: INSERT INTO ZX_TRANSACTION_LINES_GT (APPLICATION_ID,
2004: ENTITY_CODE,

Line 2003: INSERT INTO ZX_TRANSACTION_LINES_GT (APPLICATION_ID,

1999: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Temporary_Table',
2000: 'Insert into ZX_TRANSACTION_LINES_GT (+)');
2001: END IF;
2002:
2003: INSERT INTO ZX_TRANSACTION_LINES_GT (APPLICATION_ID,
2004: ENTITY_CODE,
2005: EVENT_CLASS_CODE,
2006: TRX_ID,
2007: TRX_LEVEL_TYPE,

Line 2387: FROM ZX_TRANSACTION_LINES

2383: ctrl_total_line_tx_amt,
2384: line_amt_includes_tax_flag,
2385: historical_flag
2386: --p_tax_classification_code
2387: FROM ZX_TRANSACTION_LINES
2388: WHERE APPLICATION_ID = p_application_id
2389: AND ENTITY_CODE = p_entity_code
2390: AND EVENT_CLASS_CODE = p_event_class_code
2391: AND TRX_ID = p_trx_id

Line 2398: 'Insert to ZX_TRANSACTION_LINES_GT, count : ' ||

2394:
2395: IF (g_level_procedure >= g_current_runtime_level ) THEN
2396: FND_LOG.STRING(g_level_procedure,
2397: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Temporary_Table',
2398: 'Insert to ZX_TRANSACTION_LINES_GT, count : ' ||
2399: TO_CHAR(SQL%ROWCOUNT));
2400: FND_LOG.STRING(g_level_procedure,
2401: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Temporary_Table',
2402: 'Insert into ZX_TRANSACTION_LINES_GT (-)');

Line 2402: 'Insert into ZX_TRANSACTION_LINES_GT (-)');

2398: 'Insert to ZX_TRANSACTION_LINES_GT, count : ' ||
2399: TO_CHAR(SQL%ROWCOUNT));
2400: FND_LOG.STRING(g_level_procedure,
2401: 'ZX.PLSQL.ZX_TRX_DETAIL.Insert_Temporary_Table',
2402: 'Insert into ZX_TRANSACTION_LINES_GT (-)');
2403: END IF;
2404:
2405: IF p_status = 'SIMULATOR_IMPORT' THEN
2406: RETURN;

Line 2455: FROM ZX_TRANSACTION

2451: l_sync_trx_rec.SUPPLIER_EXCHANGE_RATE,
2452: l_sync_trx_rec.TAX_INVOICE_DATE,
2453: l_sync_trx_rec.TAX_INVOICE_NUMBER,
2454: l_sync_trx_rec.PORT_OF_ENTRY_CODE
2455: FROM ZX_TRANSACTION
2456: WHERE APPLICATION_ID = p_application_id
2457: AND ENTITY_CODE = p_entity_code
2458: AND EVENT_CLASS_CODE = p_event_class_code
2459: AND TRX_ID = p_trx_id;

Line 2528: FROM ZX_TRANSACTION_LINES

2524:
2525: BEGIN
2526: SELECT COUNT(*)
2527: INTO l_trx_lines_sync
2528: FROM ZX_TRANSACTION_LINES
2529: WHERE LINE_LEVEL_ACTION = 'SYNCHORONIZE'
2530: AND APPLICATION_ID = p_application_id
2531: AND ENTITY_CODE = p_entity_code
2532: AND EVENT_CLASS_CODE = p_event_class_code

Line 2537: FROM ZX_TRANSACTION_LINES

2533: AND TRX_ID = p_trx_id;
2534:
2535: SELECT COUNT(*)
2536: INTO l_trx_lines
2537: FROM ZX_TRANSACTION_LINES
2538: WHERE APPLICATION_ID = p_application_id
2539: AND ENTITY_CODE = p_entity_code
2540: AND EVENT_CLASS_CODE = p_event_class_code
2541: AND TRX_ID = p_trx_id;

Line 2771: FROM ZX_TRANSACTION_LINES TLS

2767:
2768: CURSOR TRX_LINE_TAX IS
2769: SELECT TLS.TRX_LINE_ID,
2770: TLS.TRX_LINE_NUMBER
2771: FROM ZX_TRANSACTION_LINES TLS
2772: WHERE TLS.APPLICATION_ID = p_application_id
2773: AND TLS.ENTITY_CODE = p_entity_code
2774: AND TLS.EVENT_CLASS_CODE = p_event_class_code
2775: AND TLS.TRX_ID = p_trx_id

Line 2796: 'Update ZX_TRANSACTION_LINES (+)');

2792:
2793: IF (g_level_procedure >= g_current_runtime_level ) THEN
2794: FND_LOG.STRING(g_level_procedure,
2795: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2796: 'Update ZX_TRANSACTION_LINES (+)');
2797: END IF;
2798:
2799: IF (g_level_procedure >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_procedure,

Line 2802: 'Delete ZX_TRANSACTION_LINES (+)');

2798:
2799: IF (g_level_procedure >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_procedure,
2801: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2802: 'Delete ZX_TRANSACTION_LINES (+)');
2803: END IF;
2804:
2805: DELETE FROM ZX_TRANSACTION_LINES
2806: WHERE APPLICATION_ID = p_application_id

Line 2805: DELETE FROM ZX_TRANSACTION_LINES

2801: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2802: 'Delete ZX_TRANSACTION_LINES (+)');
2803: END IF;
2804:
2805: DELETE FROM ZX_TRANSACTION_LINES
2806: WHERE APPLICATION_ID = p_application_id
2807: AND ENTITY_CODE = p_entity_code
2808: AND EVENT_CLASS_CODE = p_event_class_code
2809: AND TRX_ID = p_trx_id

Line 2817: 'Delete ZX_TRANSACTION_LINES (-)');

2813:
2814: IF (g_level_procedure >= g_current_runtime_level ) THEN
2815: FND_LOG.STRING(g_level_procedure,
2816: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2817: 'Delete ZX_TRANSACTION_LINES (-)');
2818: END IF;
2819:
2820: LOOP
2821:

Line 2834: 'Insert ZX_TRANSACTION_LINES (+)');

2830:
2831: IF (g_level_procedure >= g_current_runtime_level ) THEN
2832: FND_LOG.STRING(g_level_procedure,
2833: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2834: 'Insert ZX_TRANSACTION_LINES (+)');
2835: END IF;
2836:
2837: INSERT INTO ZX_TRANSACTION_LINES (APPLICATION_ID,
2838: ENTITY_CODE,

Line 2837: INSERT INTO ZX_TRANSACTION_LINES (APPLICATION_ID,

2833: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2834: 'Insert ZX_TRANSACTION_LINES (+)');
2835: END IF;
2836:
2837: INSERT INTO ZX_TRANSACTION_LINES (APPLICATION_ID,
2838: ENTITY_CODE,
2839: EVENT_CLASS_CODE,
2840: TRX_LINE_ID,
2841: TRX_LINE_NUMBER,

Line 2890: 'Insert ZX_TRANSACTION_LINES (-)');

2886:
2887: IF (g_level_procedure >= g_current_runtime_level ) THEN
2888: FND_LOG.STRING(g_level_procedure,
2889: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2890: 'Insert ZX_TRANSACTION_LINES (-)');
2891: END IF;
2892:
2893: IF (g_level_procedure >= g_current_runtime_level ) THEN
2894: FND_LOG.STRING(g_level_procedure,

Line 2896: 'Update ZX_TRANSACTION_LINES (-)');

2892:
2893: IF (g_level_procedure >= g_current_runtime_level ) THEN
2894: FND_LOG.STRING(g_level_procedure,
2895: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines',
2896: 'Update ZX_TRANSACTION_LINES (-)');
2897: FND_LOG.STRING(g_level_procedure,
2898: 'ZX.PLSQL.ZX_TRX_DETAIL.Update_Transaction_Lines.END',
2899: 'ZX_TRX_DETAIL: Update_Transaction_Lines (-)');
2900: END IF;

Line 3078: 'Deleting rows from ZX_TRANSACTION');

3074:
3075: IF (g_level_statement >= g_current_runtime_level ) THEN
3076: FND_LOG.STRING(g_level_statement,
3077: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',
3078: 'Deleting rows from ZX_TRANSACTION');
3079: END IF;
3080:
3081: FORALL i IN 1 .. p_count
3082: DELETE ZX_TRANSACTION

Line 3082: DELETE ZX_TRANSACTION

3078: 'Deleting rows from ZX_TRANSACTION');
3079: END IF;
3080:
3081: FORALL i IN 1 .. p_count
3082: DELETE ZX_TRANSACTION
3083: WHERE APPLICATION_ID = p_application_id_tbl(i)
3084: AND ENTITY_CODE = p_entity_code_tbl(i)
3085: AND EVENT_CLASS_CODE = p_event_class_code_tbl(i)
3086: AND TRX_ID = p_trx_id_tbl(i);

Line 3091: 'Deleting rows from ZX_TRANSACTION_LINES');

3087:
3088: IF (g_level_statement >= g_current_runtime_level ) THEN
3089: FND_LOG.STRING(g_level_statement,
3090: 'ZX.PLSQL.ZX_TRX_DETAIL.perform_purge',
3091: 'Deleting rows from ZX_TRANSACTION_LINES');
3092: END IF;
3093:
3094: FORALL i IN 1 .. p_count
3095: DELETE ZX_TRANSACTION_LINES

Line 3095: DELETE ZX_TRANSACTION_LINES

3091: 'Deleting rows from ZX_TRANSACTION_LINES');
3092: END IF;
3093:
3094: FORALL i IN 1 .. p_count
3095: DELETE ZX_TRANSACTION_LINES
3096: WHERE APPLICATION_ID = p_application_id_tbl(i)
3097: AND ENTITY_CODE = p_entity_code_tbl(i)
3098: AND EVENT_CLASS_CODE = p_event_class_code_tbl(i)
3099: AND TRX_ID = p_trx_id_tbl(i);

Line 3410: FROM ZX_TRANSACTION_LINES TRL,

3406: TRL.TAX_STATUS_CODE,
3407: TRL.TAX_RATE_CODE,
3408: TRL.TAX_RATE,
3409: TRL.TAX_LINE_AMT
3410: FROM ZX_TRANSACTION_LINES TRL,
3411: ZX_TRANSACTION TRX
3412: WHERE TRL.TRX_ID = TRX.trx_id
3413: AND TRL.APPLICATION_ID = p_application_id
3414: AND TRL.ENTITY_CODE = p_entity_code

Line 3411: ZX_TRANSACTION TRX

3407: TRL.TAX_RATE_CODE,
3408: TRL.TAX_RATE,
3409: TRL.TAX_LINE_AMT
3410: FROM ZX_TRANSACTION_LINES TRL,
3411: ZX_TRANSACTION TRX
3412: WHERE TRL.TRX_ID = TRX.trx_id
3413: AND TRL.APPLICATION_ID = p_application_id
3414: AND TRL.ENTITY_CODE = p_entity_code
3415: AND TRL.EVENT_CLASS_CODE = p_event_class_code