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.PON_PRINTING_PKG dependencies on PON_EMD_TRANSACTIONS

Line 873: from pon_emd_transactions petr

869: 'RECEIVE_ERROR',
870: 'N',
871: 'Y') as EMD_RECEIVED,
872: (select petr.amount
873: from pon_emd_transactions petr
874: where petr.auction_header_id = p_auction_header_id
875: and petr.supplier_sequence= pbp.sequence
876: and pbp.AUCTION_HEADER_ID = petr.AUCTION_HEADER_ID
877: and (petr.status_lookup_code = 'RECEIVING'

Line 882: from pon_emd_transactions petr

878: or petr.status_lookup_code = 'RECEIVED'
879: or petr.status_lookup_code = 'RECEIVE_ERROR')
880: ) as EMD_RECEIVED_AMOUNT,
881: (select petr.TRANSACTION_DATE
882: from pon_emd_transactions petr
883: where petr.auction_header_id = p_auction_header_id
884: and petr.supplier_sequence= pbp.sequence
885: and pbp.AUCTION_HEADER_ID = petr.AUCTION_HEADER_ID
886: and (petr.status_lookup_code = 'RECEIVING'

Line 931: from pon_emd_transactions petr

927: 'RECEIVING',pet.transaction_currency_code,
928: 'RECEIVE_ERROR',pet.transaction_currency_code,
929: 'RECEIVED',pet.transaction_currency_code,
930: (select petr.transaction_currency_code
931: from pon_emd_transactions petr
932: where petr.auction_header_id = p_auction_header_id
933: and petr.supplier_sequence= pbp.sequence
934: and pbp.AUCTION_HEADER_ID = petr.AUCTION_HEADER_ID
935: and petr.status_lookup_code = 'RECEIVED')

Line 951: PON_EMD_TRANSACTIONS pet

947: pet.status_lookup_code)
948: ) as EMD_CURRENT_STATUS,
949: pet.Justification as EMD_JUSTIFICATION
950: FROM PON_bidding_parties pbp,
951: PON_EMD_TRANSACTIONS pet
952: WHERE pbp.AUCTION_HEADER_ID = p_auction_header_id
953: AND pbp.AUCTION_HEADER_ID = pet.AUCTION_HEADER_ID(+) --Modify by Chaoqun 05-Mar-2009
954: AND pbp.sequence = pet.supplier_sequence(+)
955: AND decode(pet.current_row_flag,null,'Y',pet.current_row_flag) = 'Y') AS EMD_SUMMARY,

Line 1062: from pon_emd_transactions petr,

1058: 'N', 'NOT_PAID',
1059: 'Y', 'EXEMPTED'),
1060: petr.status_lookup_code)
1061: into l_emd_current_status
1062: from pon_emd_transactions petr,
1063: pon_bidding_parties pbp
1064: where pbp.sequence=p_supplier_sequence
1065: and pbp.auction_header_id= p_auction_header_id
1066: and petr.auction_header_id(+) = pbp.auction_header_id

Line 1082: from pon_emd_transactions petr

1078: petr.Org_Id
1079: into l_cust_trx_id,
1080: l_cust_trx_num,
1081: l_org_id
1082: from pon_emd_transactions petr
1083: where petr.auction_header_id = p_auction_header_id
1084: and petr.status_lookup_code = 'RECEIVED'
1085: and petr.supplier_sequence = p_supplier_sequence;
1086: exception

Line 1221: from pon_emd_transactions petr

1217: 'RECEIVE_ERROR',
1218: 'N',
1219: 'Y') as EMD_RECEIVED_FLAG,
1220: (select petr.amount
1221: from pon_emd_transactions petr
1222: where petr.auction_header_id = p_auction_header_id
1223: and petr.supplier_sequence= p_supplier_sequence
1224: and (petr.status_lookup_code = 'RECEIVING'
1225: or petr.status_lookup_code = 'RECEIVED'

Line 1228: from pon_emd_transactions petr

1224: and (petr.status_lookup_code = 'RECEIVING'
1225: or petr.status_lookup_code = 'RECEIVED'
1226: or petr.status_lookup_code = 'RECEIVE_ERROR')) as EMD_RECEIVED_AMOUNT,
1227: (select petr.TRANSACTION_DATE
1228: from pon_emd_transactions petr
1229: where petr.auction_header_id = p_auction_header_id
1230: and petr.supplier_sequence= p_supplier_sequence
1231: and (petr.status_lookup_code = 'RECEIVING'
1232: or petr.status_lookup_code = 'RECEIVED'

Line 1235: from PON_EMD_TRANSACTIONS petr,

1231: and (petr.status_lookup_code = 'RECEIVING'
1232: or petr.status_lookup_code = 'RECEIVED'
1233: or petr.status_lookup_code = 'RECEIVE_ERROR')) as EMD_RECEIVED_DATE,
1234: (select flv.meaning
1235: from PON_EMD_TRANSACTIONS petr,
1236: fnd_lookup_values flv
1237: where petr.AUCTION_HEADER_ID = p_auction_header_id
1238: AND petr.SUPPLIER_SEQUENCE = p_supplier_sequence
1239: AND flv.lookup_type = 'PON_EMD_PAYMENT_METHOD'

Line 1247: from pon_emd_transactions petr

1243: or petr.status_lookup_code = 'RECEIVED'
1244: or petr.status_lookup_code = 'RECEIVE_ERROR')) as EMD_PAYMENT_TYPE,
1245: decode(l_emd_current_status, 'REFUNDED', 'Y', 'N') as EMD_REFUNDED_FLAG,
1246: (select petr.amount
1247: from pon_emd_transactions petr
1248: where petr.auction_header_id = p_auction_header_id
1249: and petr.supplier_sequence= p_supplier_sequence
1250: and (petr.status_lookup_code = 'REFUNDING'
1251: or petr.status_lookup_code = 'REFUNDED'

Line 1254: from pon_emd_transactions petr

1250: and (petr.status_lookup_code = 'REFUNDING'
1251: or petr.status_lookup_code = 'REFUNDED'
1252: or petr.status_lookup_code = 'REFUND_ERROR')) as EMD_REFUNDED_AMOUNT,
1253: (select petr.TRANSACTION_DATE
1254: from pon_emd_transactions petr
1255: where petr.auction_header_id = p_auction_header_id
1256: and petr.supplier_sequence= p_supplier_sequence
1257: and (petr.status_lookup_code = 'REFUNDING'
1258: or petr.status_lookup_code = 'REFUNDED'

Line 1262: from pon_emd_transactions petr

1258: or petr.status_lookup_code = 'REFUNDED'
1259: or petr.status_lookup_code = 'REFUND_ERROR')) as EMD_REFUNDED_DATE,
1260: decode(l_emd_current_status, 'FORFEITED', 'Y', 'N') as EMD_FORFEITED_FLAG,
1261: (select petr.amount
1262: from pon_emd_transactions petr
1263: where petr.auction_header_id = p_auction_header_id
1264: and petr.supplier_sequence= p_supplier_sequence
1265: and (petr.status_lookup_code = 'FORFEITING'
1266: or petr.status_lookup_code = 'FORFEITED'

Line 1269: from pon_emd_transactions petr

1265: and (petr.status_lookup_code = 'FORFEITING'
1266: or petr.status_lookup_code = 'FORFEITED'
1267: or petr.status_lookup_code = 'FORFEIT_ERROR')) as EMD_FORFEITED_AMOUNT,
1268: (select petr.TRANSACTION_DATE
1269: from pon_emd_transactions petr
1270: where petr.auction_header_id = p_auction_header_id
1271: and petr.supplier_sequence= p_supplier_sequence
1272: and (petr.status_lookup_code = 'FORFEITING'
1273: or petr.status_lookup_code = 'FORFEITED'

Line 1355: from pon_emd_transactions petr,

1351: petr.JUSTIFICATION,
1352: null) as EMD_FORFEIT_JUSTIFICATION,
1353: --End: Addde by Chaoqun on 22-DEC-2008
1354: petr.emd_transaction_id as TRX_ID
1355: from pon_emd_transactions petr,
1356: pon_bidding_parties pbp,
1357: fnd_lookup_values flv,
1358: IBY_CREDITCARD cc
1359: where petr.auction_header_id = p_auction_header_id

Line 1412: pon_emd_transactions petr,

1408: )
1409: and application_id = 396
1410: and language_code = l_printing_language) as GENERIC_MESSAGES
1411: from pon_auction_headers_all paha,
1412: pon_emd_transactions petr,
1413: pon_bidding_parties pbp,
1414: fnd_lookup_values fl,
1415: fnd_lookups fl1,
1416: pon_auc_doctypes doc,

Line 1485: --l_emd_current_status pon_emd_transactions.status_lookup_code%type;

1481: l_current_log_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1482: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1483: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_RECEIPT_XML';
1484: --p_supplier_id := 12438;
1485: --l_emd_current_status pon_emd_transactions.status_lookup_code%type;
1486: TYPE emd_current_status_type is ref cursor;
1487: emd_current_status emd_current_status_type;
1488:
1489: BEGIN

Line 1494: from pon_emd_transactions petr

1490: --Begin: Deleted by Chaoqun on 19-Mar-2009
1491:
1492: /* open emd_current_status for
1493: select petr.status_lookup_code
1494: from pon_emd_transactions petr
1495: where petr.auction_header_id = p_auction_header_id
1496: and petr.supplier_sequence= p_supplier_sequence
1497: order by petr.emd_transaction_id;
1498:

Line 1556: from pon_emd_transactions petr,

1552: petr.EXPIRY_DATE as EMD_EXPIRATION_DATE,
1553: petr.TYPE_OF_CARD as EMD_TYPE_OF_CARD,
1554: flv.meaning as EMD_DETAIL_PAYTYPE,
1555: petr.emd_transaction_id as TRX_ID
1556: from pon_emd_transactions petr,
1557: fnd_lookup_values flv,
1558: IBY_CREDITCARD cc
1559: where petr.auction_header_id = p_auction_header_id
1560: and petr.supplier_sequence = p_supplier_sequence

Line 1589: from pon_emd_transactions petr

1585: petr.document_number as EMD_DETAIL_DOC_NO,
1586: petr.cust_trx_number as EMD_DETAIL_TRX_NO,
1587: petr.credit_card_num as EMD_DETAIL_CRE_NO,
1588: petr.emd_transaction_id as TRX_ID
1589: from pon_emd_transactions petr
1590: where petr.auction_header_id = p_auction_header_id
1591: and petr.supplier_sequence= p_supplier_sequence
1592: and (petr.status_lookup_code = 'RECEIVED'
1593: or petr.status_lookup_code = 'RECEIVE_ERROR'

Line 1630: pon_emd_transactions petr,

1626: )
1627: and application_id = 396
1628: and language_code = l_printing_language) as GENERIC_MESSAGES
1629: from pon_auction_headers_all paha,
1630: pon_emd_transactions petr,
1631: pon_bidding_parties pbp,
1632: fnd_lookup_values flv,
1633: HR_ALL_ORGANIZATION_UNITS_TL ou,
1634: pon_auc_doctypes doc,