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.

[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on ZX_VALIDATION_ERRORS_GT

Line 5234: from ZX_VALIDATION_ERRORS_GT

5230: fsp.set_of_books_id,
5231: aps.base_currency_code,
5232: oi.org_information2 oi_org_information2
5233: FROM (select distinct other_doc_trx_id
5234: from ZX_VALIDATION_ERRORS_GT
5235: where other_doc_application_id = 201
5236: and other_doc_entity_code = 'PURCHASE_ORDER'
5237: and other_doc_event_class_code = 'PO_PA'
5238: ) zxvalerr, --Bug 5187701

Line 5921: from ZX_VALIDATION_ERRORS_GT

5917: FROM (SELECT /*+ NO_MERGE NO_EXPAND use_hash(fsp) use_hash(aps) use_hash(oi) swap_join_inputs(fsp) swap_join_inputs(aps) swap_join_inputs(oi) */
5918: poh.* , fsp.org_id fsp_org_id, fsp.set_of_books_id,
5919: aps.base_currency_code, oi.org_information2 oi_org_information2
5920: FROM (select distinct other_doc_trx_id
5921: from ZX_VALIDATION_ERRORS_GT
5922: where other_doc_application_id = 201
5923: and other_doc_entity_code = 'PURCHASE_ORDER'
5924: and other_doc_event_class_code = 'PO_PA'
5925: ) zxvalerr, --Bug 5187701

Line 6629: from ZX_VALIDATION_ERRORS_GT

6625: FROM (SELECT /*+ NO_MERGE NO_EXPAND use_hash(fsp) use_hash(aps) use_hash(oi) swap_join_inputs(fsp) swap_join_inputs(aps) swap_join_inputs(oi) */
6626: poh.* , fsp.org_id fsp_org_id, fsp.set_of_books_id,
6627: aps.base_currency_code, oi.org_information2 oi_org_information2
6628: FROM (select distinct other_doc_trx_id
6629: from ZX_VALIDATION_ERRORS_GT
6630: where other_doc_application_id = 201
6631: and other_doc_entity_code = 'PURCHASE_ORDER'
6632: and other_doc_event_class_code = 'PO_PA'
6633: ) zxvalerr, --Bug 5187701

Line 7107: from ZX_VALIDATION_ERRORS_GT

7103: pod.attribute13 p_attribute13,
7104: pod.attribute14 p_attribute14,
7105: pod.attribute15 p_attribute15
7106: FROM (select distinct other_doc_trx_id
7107: from ZX_VALIDATION_ERRORS_GT
7108: where other_doc_application_id = 201
7109: and other_doc_entity_code = 'PURCHASE_ORDER'
7110: and other_doc_event_class_code = 'PO_PA'
7111: ) zxvalerr, --Bug 5187701

Line 7555: from ZX_VALIDATION_ERRORS_GT

7551: fsp.set_of_books_id fsp_set_of_books_id,
7552: aps.base_currency_code aps_base_currency_code,
7553: oi.org_information2 oi_org_information2
7554: FROM (select distinct other_doc_trx_id
7555: from ZX_VALIDATION_ERRORS_GT
7556: where other_doc_application_id = 201
7557: and other_doc_entity_code = 'RELEASE'
7558: and other_doc_event_class_code = 'RELEASE'
7559: ) zxvalerr,

Line 8252: from ZX_VALIDATION_ERRORS_GT

8248: fsp.org_id fsp_org_id,
8249: aps.base_currency_code aps_base_currency_code,
8250: oi.org_information2 oi_org_information2
8251: FROM (select distinct other_doc_trx_id
8252: from ZX_VALIDATION_ERRORS_GT
8253: where other_doc_application_id = 201
8254: and other_doc_entity_code = 'RELEASE'
8255: and other_doc_event_class_code = 'RELEASE'
8256: ) zxvalerr,

Line 8969: from ZX_VALIDATION_ERRORS_GT

8965: fsp.org_id fsp_org_id,
8966: aps.base_currency_code aps_base_currency_code,
8967: oi.org_information2 oi_org_information2
8968: FROM (select distinct other_doc_trx_id
8969: from ZX_VALIDATION_ERRORS_GT
8970: where other_doc_application_id = 201
8971: and other_doc_entity_code = 'RELEASE'
8972: and other_doc_event_class_code = 'RELEASE'
8973: ) zxvalerr,

Line 9446: from ZX_VALIDATION_ERRORS_GT

9442: pod.attribute13 p_attribute13,
9443: pod.attribute14 p_attribute14,
9444: pod.attribute15 p_attribute15
9445: FROM (select distinct other_doc_trx_id
9446: from ZX_VALIDATION_ERRORS_GT
9447: where other_doc_application_id = 201
9448: and other_doc_entity_code = 'RELEASE'
9449: and other_doc_event_class_code = 'RELEASE')
9450: zxvalerr,