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.DPP_BUSINESSEVENTS_PVT dependencies on DPP_TRANSACTION_HEADERS_ALL

Line 293: FROM dpp_transaction_headers_all headers

289: headers.trx_currency currency
290: FROM dpp_transaction_lines_all lines
291: WHERE headers.Transaction_header_id = lines.Transaction_header_id
292: AND nvl(lines.UPDATE_ITEM_LIST_PRICE,''N'') = ''N'') LINES
293: FROM dpp_transaction_headers_all headers
294: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
295: 'AND EXISTS (SELECT Transaction_header_id
296: FROM dpp_transaction_lines_all
297: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 347: FROM dpp_transaction_headers_all headers

343: headers.trx_currency currency
344: FROM dpp_transaction_lines_all lines
345: WHERE headers.Transaction_header_id = lines.Transaction_header_id
346: AND nvl(lines.NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'') LINES
347: FROM dpp_transaction_headers_all headers
348: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
349: 'AND EXISTS (SELECT Transaction_header_id
350: FROM dpp_transaction_lines_all
351: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 438: FROM dpp_transaction_headers_all headers

434: headers.trx_currency currency
435: FROM dpp_transaction_lines_all lines
436: WHERE headers.Transaction_header_id = lines.Transaction_header_id
437: AND lines.supp_dist_claim_id = '||p_txn_hdr_rec.claim_id||') LINES
438: FROM dpp_transaction_headers_all headers
439: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID
440: );
441: dbms_xmlquery.setRowTag(l_queryCtx
442: , 'HEADER'

Line 470: FROM dpp_transaction_headers_all headers

466: headers.trx_currency currency
467: FROM dpp_transaction_lines_all lines
468: WHERE headers.Transaction_header_id = lines.Transaction_header_id
469: AND nvl(lines.NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'') LINES
470: FROM dpp_transaction_headers_all headers
471: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
472: 'AND EXISTS (SELECT Transaction_header_id
473: FROM dpp_transaction_lines_all
474: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 524: FROM dpp_transaction_headers_all headers

520: headers.trx_currency currency
521: FROM dpp_transaction_lines_all lines
522: WHERE headers.Transaction_header_id = lines.Transaction_header_id
523: AND nvl(lines.NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'') LINES
524: FROM dpp_transaction_headers_all headers
525: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
526: 'AND EXISTS (SELECT Transaction_header_id
527: FROM dpp_transaction_lines_all
528: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 565: dpp_transaction_headers_all dtha

561: BEGIN
562: SELECT ostp.gl_cost_adjustment_acct
563: INTO l_cost_adj_acct
564: FROM ozf_supp_trd_prfls_all ostp,
565: dpp_transaction_headers_all dtha
566: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
567: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
568: AND ostp.org_id = to_number(dtha.org_id)
569: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;

Line 591: dpp_transaction_headers_all dtha

587: BEGIN
588: SELECT osp.gl_cost_adjustment_acct
589: INTO l_cost_adj_acct
590: FROM ozf_sys_parameters osp,
591: dpp_transaction_headers_all dtha
592: WHERE osp.org_id = to_number(dtha.org_id)
593: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN

Line 641: FROM dpp_transaction_headers_all headers

637: price_change
638: FROM dpp_transaction_lines_all lines
639: WHERE headers.Transaction_header_id = lines.Transaction_header_id
640: AND nvl(lines.UPDATE_INVENTORY_COSTING,''N'') = ''N'') LINES
641: FROM dpp_transaction_headers_all headers
642: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
643: 'AND EXISTS (SELECT Transaction_header_id
644: FROM dpp_transaction_lines_all
645: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 707: FROM dpp_transaction_headers_all headers

703: headers.trx_currency currency
704: FROM dpp_transaction_lines_all lines
705: WHERE headers.Transaction_header_id = lines.Transaction_header_id
706: AND nvl(lines.NOTIFY_PURCHASING_DOCS,''N'') <> ''D'') LINES
707: FROM dpp_transaction_headers_all headers
708: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
709: 'AND EXISTS (SELECT Transaction_header_id
710: FROM dpp_transaction_lines_all
711: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 759: FROM dpp_transaction_headers_all headers

755: headers.trx_currency currency
756: FROM dpp_transaction_lines_all lines
757: WHERE headers.Transaction_header_id = lines.Transaction_header_id
758: AND nvl(lines.UPDATE_PURCHASING_DOCS,''N'') = ''N'') LINES
759: FROM dpp_transaction_headers_all headers
760: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
761: 'AND EXISTS (SELECT Transaction_header_id
762: FROM dpp_transaction_lines_all
763: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 800: dpp_transaction_headers_all dtha

796: BEGIN
797: SELECT nvl(create_claim_price_increase,'N')
798: INTO l_price_change_flag
799: FROM ozf_supp_trd_prfls_all ostp,
800: dpp_transaction_headers_all dtha
801: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
802: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
803: AND ostp.org_id = to_number(dtha.org_id)
804: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;

Line 862: FROM dpp_transaction_headers_all headers

858: AND dtl.transaction_line_id = dtlg.transaction_line_id
859: AND '||dtl_price_change||'
860: AND nvl(dtl.approved_inventory,0) > 0
861: AND nvl(dtl.SUPP_DIST_CLAIM_STATUS,''N'') = ''N'') LINES
862: FROM dpp_transaction_headers_all headers
863: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
864: 'AND EXISTS (SELECT dtla.Transaction_header_id
865: FROM dpp_transaction_lines_all dtla,
866: DPP_TRANSACTION_LINES_GT dtg

Line 972: FROM dpp_transaction_headers_all headers

968: AND dcc.customer_inv_line_id = dtg.transaction_line_id
969: AND nvl(dcc.reported_inventory,0) > 0
970: AND nvl(dcc.supp_claim_amt,0) > 0
971: AND nvl(dcc.supplier_claim_created,''N'') = ''N'') LINES
972: FROM dpp_transaction_headers_all headers
973: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
974: 'AND EXISTS (SELECT dcca.Transaction_header_id
975: FROM DPP_customer_claims_all dcca,
976: DPP_TRANSACTION_LINES_GT dtga

Line 1052: FROM dpp_transaction_headers_all headers

1048: AND dcc.customer_inv_line_id = dtg.transaction_line_id
1049: AND nvl(dcc.reported_inventory,0) > 0
1050: AND nvl(dcc.cust_claim_amt,0) > 0
1051: AND nvl(dcc.customer_claim_created,''N'') = ''N'') LINES
1052: FROM dpp_transaction_headers_all headers
1053: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1054: 'AND EXISTS (SELECT dcca.Transaction_header_id
1055: FROM DPP_customer_claims_all dcca,
1056: DPP_TRANSACTION_LINES_GT dtga

Line 1091: FROM dpp_transaction_headers_all headers

1087: UOM
1088: FROM dpp_transaction_lines_all lines
1089: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1090: AND lines.price_change > 0 ) LINES
1091: FROM dpp_transaction_headers_all headers
1092: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1093: 'AND EXISTS (SELECT Transaction_header_id
1094: FROM dpp_transaction_lines_all
1095: WHERE price_change > 0

Line 1123: FROM dpp_transaction_headers_all headers

1119: CURSOR(select transaction_line_id,
1120: inventory_item_id
1121: FROM dpp_transaction_lines_all lines
1122: WHERE headers.Transaction_header_id = lines.Transaction_header_id) LINES
1123: FROM dpp_transaction_headers_all headers
1124: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1125: 'AND EXISTS (SELECT Transaction_header_id
1126: FROM dpp_transaction_lines_all
1127: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||')'