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_VALIDATE_API_PKG dependencies on ZX_LINES

Line 287: FROM ZX_LINES_DET_FACTORS linedet

283: -- Bug # 4697301
284: DELETE FROM ZX_VALIDATION_ERRORS_GT err
285: WHERE EXISTS
286: (SELECT 1
287: FROM ZX_LINES_DET_FACTORS linedet
288: WHERE linedet.application_id = err.other_doc_application_id
289: AND linedet.entity_code = err.other_doc_entity_code
290: AND linedet.event_class_code = err.other_doc_event_class_code
291: AND linedet.trx_id = err.other_doc_trx_id

Line 6010: FROM zx_lines zl

6006: CASE
6007: WHEN lines_gt.applied_from_application_id IS NOT NULL
6008: AND NOT EXISTS
6009: (SELECT 1
6010: FROM zx_lines zl
6011: WHERE zl.application_id = lines_gt.applied_from_application_id
6012: AND zl.entity_code = lines_gt.applied_from_entity_code
6013: AND zl.event_class_code = lines_gt.applied_from_event_class_code
6014: AND zl.trx_id = lines_gt.applied_from_trx_id

Line 6086: FROM zx_lines zl

6082: CASE
6083: WHEN lines_gt.adjusted_doc_application_id IS NOT NULL
6084: AND NOT EXISTS
6085: (SELECT 1
6086: FROM zx_lines zl
6087: WHERE zl.application_id = lines_gt.adjusted_doc_application_id
6088: AND zl.entity_code = lines_gt.adjusted_doc_entity_code
6089: AND zl.event_class_code = lines_gt.adjusted_doc_event_class_code
6090: AND zl.trx_id = lines_gt.adjusted_doc_trx_id

Line 6549: FROM zx_lines zl

6545: CASE
6546: WHEN lines_gt.applied_from_application_id IS NOT NULL
6547: AND NOT EXISTS
6548: (SELECT 1
6549: FROM zx_lines zl
6550: WHERE zl.application_id = lines_gt.applied_from_application_id
6551: AND zl.entity_code = lines_gt.applied_from_entity_code
6552: AND zl.event_class_code = lines_gt.applied_from_event_class_code
6553: AND zl.trx_id = lines_gt.applied_from_trx_id

Line 6625: FROM zx_lines zl

6621: CASE
6622: WHEN lines_gt.adjusted_doc_application_id IS NOT NULL
6623: AND NOT EXISTS
6624: (SELECT 1
6625: FROM zx_lines zl
6626: WHERE zl.application_id = lines_gt.adjusted_doc_application_id
6627: AND zl.entity_code = lines_gt.adjusted_doc_entity_code
6628: AND zl.event_class_code = lines_gt.adjusted_doc_event_class_code
6629: AND zl.trx_id = lines_gt.adjusted_doc_trx_id

Line 7104: FROM zx_lines zl

7100: CASE
7101: WHEN lines_gt.applied_from_application_id IS NOT NULL
7102: AND NOT EXISTS
7103: (SELECT 1
7104: FROM zx_lines zl
7105: WHERE zl.application_id = lines_gt.applied_from_application_id
7106: AND zl.entity_code = lines_gt.applied_from_entity_code
7107: AND zl.event_class_code = lines_gt.applied_from_event_class_code
7108: AND zl.trx_id = lines_gt.applied_from_trx_id

Line 7180: FROM zx_lines zl

7176: CASE
7177: WHEN lines_gt.adjusted_doc_application_id IS NOT NULL
7178: AND NOT EXISTS
7179: (SELECT 1
7180: FROM zx_lines zl
7181: WHERE zl.application_id = lines_gt.adjusted_doc_application_id
7182: AND zl.entity_code = lines_gt.adjusted_doc_entity_code
7183: AND zl.event_class_code = lines_gt.adjusted_doc_event_class_code
7184: AND zl.trx_id = lines_gt.adjusted_doc_trx_id

Line 8805: -- Check for existence of related documents in zx lines det factors table

8801: lines_gt.adjusted_doc_entity_code adj_doc_entity_code,
8802: lines_gt.adjusted_doc_event_class_code adj_doc_event_class_code,
8803: lines_gt.adjusted_doc_trx_id adj_doc_trx_id,
8804:
8805: -- Check for existence of related documents in zx lines det factors table
8806: -- Since the Selection is at the granularity of the transaction lines, also check for existence of
8807: -- error record in validaiton errors gt to avoid inserting header level errors multiple times
8808: -- Also check in zx trx headers gt if this doc is already present
8809: nvl2( header.related_doc_trx_id,

Line 8811: (SELECT 1 FROM ZX_LINES_DET_FACTORS

8807: -- error record in validaiton errors gt to avoid inserting header level errors multiple times
8808: -- Also check in zx trx headers gt if this doc is already present
8809: nvl2( header.related_doc_trx_id,
8810: CASE WHEN ((NOT EXISTS
8811: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8812: WHERE application_id = header.related_doc_application_id
8813: AND entity_code = header.related_doc_entity_code
8814: AND event_class_code = header.related_doc_event_class_code
8815: AND trx_id = header.related_doc_trx_id))

Line 8834: -- Check for existence of reference documents in zx lines det factors table and zx trx lines gt

8830: THEN 'Y'
8831: ELSE NULL END,
8832: NULL) ZX_REL_DOC_MISSING,
8833:
8834: -- Check for existence of reference documents in zx lines det factors table and zx trx lines gt
8835: nvl2( lines_gt.ref_doc_trx_id,
8836: CASE WHEN lines_gt.ref_doc_application_id = 201
8837: AND lines_gt.ref_doc_entity_code = 'RELEASE'
8838: AND lines_gt.ref_doc_event_class_code = 'RELEASE'

Line 8842: FROM ZX_LINES_DET_FACTORS

8838: AND lines_gt.ref_doc_event_class_code = 'RELEASE'
8839: THEN NULL
8840: WHEN ((NOT EXISTS
8841: (SELECT 1
8842: FROM ZX_LINES_DET_FACTORS
8843: WHERE application_id = lines_gt.ref_doc_application_id
8844: AND entity_code = lines_gt.ref_doc_entity_code
8845: AND event_class_code = lines_gt.ref_doc_event_class_code
8846: AND trx_id = lines_gt.ref_doc_trx_id

Line 8866: -- Check for applied from documents in zx lines det factors table and zx trx lines gt

8862: ELSE NULL
8863: END,
8864: NULL) ZX_REF_DOC_MISSING,
8865:
8866: -- Check for applied from documents in zx lines det factors table and zx trx lines gt
8867: nvl2( lines_gt.applied_from_trx_id,
8868: CASE WHEN ((NOT EXISTS
8869: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8870: WHERE application_id = lines_gt.applied_from_application_id

Line 8869: (SELECT 1 FROM ZX_LINES_DET_FACTORS

8865:
8866: -- Check for applied from documents in zx lines det factors table and zx trx lines gt
8867: nvl2( lines_gt.applied_from_trx_id,
8868: CASE WHEN ((NOT EXISTS
8869: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8870: WHERE application_id = lines_gt.applied_from_application_id
8871: AND entity_code = lines_gt.applied_from_entity_code
8872: AND event_class_code = lines_gt.applied_from_event_class_code
8873: AND trx_id = lines_gt.applied_from_trx_id

Line 8891: -- Check for adjusted document in zx lines det factors table and zx trx lines gt

8887: ELSE NULL
8888: END,
8889: NULL) ZX_APP_FROM_DOC_MISSING,
8890:
8891: -- Check for adjusted document in zx lines det factors table and zx trx lines gt
8892: nvl2( lines_gt.adjusted_doc_trx_id,
8893: CASE WHEN ((NOT EXISTS
8894: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8895: WHERE application_id = lines_gt.adjusted_doc_application_id

Line 8894: (SELECT 1 FROM ZX_LINES_DET_FACTORS

8890:
8891: -- Check for adjusted document in zx lines det factors table and zx trx lines gt
8892: nvl2( lines_gt.adjusted_doc_trx_id,
8893: CASE WHEN ((NOT EXISTS
8894: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8895: WHERE application_id = lines_gt.adjusted_doc_application_id
8896: AND entity_code = lines_gt.adjusted_doc_entity_code
8897: AND event_class_code = lines_gt.adjusted_doc_event_class_code
8898: AND trx_id = lines_gt.adjusted_doc_trx_id

Line 8916: -- Check for applied to documents in zx lines det factors table and zx trx lines gt

8912: ELSE NULL
8913: END,
8914: NULL) ZX_ADJ_DOC_MISSING,
8915:
8916: -- Check for applied to documents in zx lines det factors table and zx trx lines gt
8917:
8918: /* Since we do not store applied to document (receipt), we should
8919: not check whether the doc exists in eTax repository
8920:

Line 8923: (SELECT 1 FROM ZX_LINES_DET_FACTORS

8919: not check whether the doc exists in eTax repository
8920:
8921: nvl2( lines_gt.applied_to_trx_id,
8922: CASE WHEN ((NOT EXISTS
8923: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8924: WHERE application_id = lines_gt.applied_to_application_id
8925: AND entity_code = lines_gt.applied_to_entity_code
8926: AND event_class_code = lines_gt.applied_to_event_class_code
8927: AND trx_id = lines_gt.applied_to_trx_id

Line 8943: -- Check for source documents in zx lines det factors table and zx trx lines gt

8939: ELSE NULL END,
8940: NULL) ZX_APP_TO_DOC_MISSING,
8941: */
8942:
8943: -- Check for source documents in zx lines det factors table and zx trx lines gt
8944: nvl2( lines_gt.source_trx_id,
8945: CASE WHEN ((NOT EXISTS
8946: (SELECT 1
8947: FROM ZX_LINES_DET_FACTORS line,

Line 8947: FROM ZX_LINES_DET_FACTORS line,

8943: -- Check for source documents in zx lines det factors table and zx trx lines gt
8944: nvl2( lines_gt.source_trx_id,
8945: CASE WHEN ((NOT EXISTS
8946: (SELECT 1
8947: FROM ZX_LINES_DET_FACTORS line,
8948: ZX_EVNT_CLS_MAPPINGS map
8949: WHERE lines_gt.application_id = map.application_id
8950: AND lines_gt.entity_code = map.entity_code
8951: AND lines_gt.event_class_code = map.event_class_code