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 254: FROM DPP_TRANSACTION_HEADERS_ALL

250: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
251:
252: SELECT TRANSACTION_NUMBER
253: INTO L_TXN_HDR_NUM
254: FROM DPP_TRANSACTION_HEADERS_ALL
255: WHERE TRANSACTION_HEADER_ID = P_TXN_HDR_ID;
256:
257: L_TXN_HDR_REC := NULL;
258: L_TXN_LINE_ID.DELETE();

Line 486: FROM DPP_TRANSACTION_HEADERS_ALL H, FND_USER U

482: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.SEND_EFFECTIVE_DATE_NOTIF';
483:
484: CURSOR GET_USER_LIST (P_PROGRAM_ID VARCHAR2) IS
485: SELECT DISTINCT H.CREATED_BY, U.USER_NAME
486: FROM DPP_TRANSACTION_HEADERS_ALL H, FND_USER U
487: WHERE TRUNC(H.EFFECTIVE_START_DATE) < TRUNC(SYSDATE)
488: AND H.REQUEST_ID=P_PROGRAM_ID
489: AND H.TRANSACTION_STATUS = 'PENDING_ADJUSTMENT'
490: AND H.CREATED_BY=U.USER_ID;

Line 811: FROM dpp_transaction_headers_all headers

807: headers.trx_currency currency
808: FROM dpp_transaction_lines_all lines
809: WHERE headers.Transaction_header_id = lines.Transaction_header_id
810: AND nvl(lines.UPDATE_ITEM_LIST_PRICE,''N'') = ''N'') LINES
811: FROM dpp_transaction_headers_all headers
812: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
813: 'AND EXISTS (SELECT Transaction_header_id
814: FROM dpp_transaction_lines_all
815: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 866: FROM dpp_transaction_headers_all headers

862: headers.trx_currency currency
863: FROM dpp_transaction_lines_all lines
864: WHERE headers.Transaction_header_id = lines.Transaction_header_id
865: AND nvl(lines.NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'') LINES
866: FROM dpp_transaction_headers_all headers
867: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
868: 'AND EXISTS (SELECT Transaction_header_id
869: FROM dpp_transaction_lines_all
870: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 907: FROM dpp_transaction_headers_all

903: --Calculate the value of the claim header amount
904: BEGIN
905: SELECT trx_currency
906: INTO l_trx_currency
907: FROM dpp_transaction_headers_all
908: WHERE transaction_header_id = p_txn_hdr_rec.transaction_header_id;
909:
910: SELECT SUM(DPP_UTILITY_PVT.CurrRound(nvl(claim_amount,0), l_trx_currency))
911: INTO l_claim_hdr_amt

Line 962: FROM dpp_transaction_headers_all headers

958: headers.trx_currency currency
959: FROM dpp_transaction_lines_all lines
960: WHERE headers.Transaction_header_id = lines.Transaction_header_id
961: AND lines.supp_dist_claim_id = '||p_txn_hdr_rec.claim_id||') LINES
962: FROM dpp_transaction_headers_all headers
963: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID
964: );
965: dbms_xmlquery.setRowTag(l_queryCtx
966: , 'HEADER'

Line 995: FROM dpp_transaction_headers_all headers

991: headers.trx_currency currency
992: FROM dpp_transaction_lines_all lines
993: WHERE headers.Transaction_header_id = lines.Transaction_header_id
994: AND nvl(lines.NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'') LINES
995: FROM dpp_transaction_headers_all headers
996: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
997: 'AND EXISTS (SELECT Transaction_header_id
998: FROM dpp_transaction_lines_all
999: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 1050: FROM dpp_transaction_headers_all headers

1046: headers.trx_currency currency
1047: FROM dpp_transaction_lines_all lines
1048: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1049: AND nvl(lines.NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'') LINES
1050: FROM dpp_transaction_headers_all headers
1051: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1052: 'AND EXISTS (SELECT Transaction_header_id
1053: FROM dpp_transaction_lines_all
1054: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 1091: dpp_transaction_headers_all dtha

1087: BEGIN
1088: SELECT ostp.gl_cost_adjustment_acct
1089: INTO l_cost_adj_acct
1090: FROM ozf_supp_trd_prfls_all ostp,
1091: dpp_transaction_headers_all dtha
1092: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
1093: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
1094: AND ostp.org_id = to_number(dtha.org_id)
1095: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;

Line 1117: dpp_transaction_headers_all dtha

1113: BEGIN
1114: SELECT osp.gl_cost_adjustment_acct
1115: INTO l_cost_adj_acct
1116: FROM ozf_sys_parameters osp,
1117: dpp_transaction_headers_all dtha
1118: WHERE osp.org_id = to_number(dtha.org_id)
1119: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN

Line 1166: FROM dpp_transaction_headers_all headers

1162: price_change
1163: FROM dpp_transaction_lines_all lines
1164: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1165: AND nvl(lines.UPDATE_INVENTORY_COSTING,''N'') = ''N'') LINES
1166: FROM dpp_transaction_headers_all headers
1167: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1168: 'AND EXISTS (SELECT Transaction_header_id
1169: FROM dpp_transaction_lines_all
1170: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 1233: FROM dpp_transaction_headers_all headers

1229: headers.trx_currency currency
1230: FROM dpp_transaction_lines_all lines
1231: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1232: AND nvl(lines.NOTIFY_PURCHASING_DOCS,''N'') <> ''D'') LINES
1233: FROM dpp_transaction_headers_all headers
1234: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1235: 'AND EXISTS (SELECT Transaction_header_id
1236: FROM dpp_transaction_lines_all
1237: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 1285: FROM dpp_transaction_headers_all headers

1281: headers.trx_currency currency
1282: FROM dpp_transaction_lines_all lines
1283: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1284: AND nvl(lines.UPDATE_PURCHASING_DOCS,''N'') = ''N'') LINES
1285: FROM dpp_transaction_headers_all headers
1286: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1287: 'AND EXISTS (SELECT Transaction_header_id
1288: FROM dpp_transaction_lines_all
1289: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'

Line 1326: dpp_transaction_headers_all dtha

1322: BEGIN
1323: SELECT nvl(create_claim_price_increase,'N')
1324: INTO l_price_change_flag
1325: FROM ozf_supp_trd_prfls_all ostp,
1326: dpp_transaction_headers_all dtha
1327: WHERE ostp.supplier_id = to_number(dtha.vendor_id)
1328: AND ostp.supplier_site_id = to_number(dtha.vendor_site_id)
1329: AND ostp.org_id = to_number(dtha.org_id)
1330: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;

Line 1388: FROM dpp_transaction_headers_all headers

1384: AND dtl.transaction_line_id = dtlg.transaction_line_id
1385: AND '||dtl_price_change||'
1386: AND nvl(dtl.approved_inventory,0) > 0
1387: AND nvl(dtl.SUPP_DIST_CLAIM_STATUS,''N'') = ''N'') LINES
1388: FROM dpp_transaction_headers_all headers
1389: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1390: 'AND EXISTS (SELECT dtla.Transaction_header_id
1391: FROM dpp_transaction_lines_all dtla,
1392: DPP_TRANSACTION_LINES_GT dtg

Line 1498: FROM dpp_transaction_headers_all headers

1494: AND dcc.customer_inv_line_id = dtg.transaction_line_id
1495: AND nvl(dcc.reported_inventory,0) > 0
1496: AND nvl(dcc.supp_claim_amt,0) > 0
1497: AND nvl(dcc.supplier_claim_created,''N'') = ''N'') LINES
1498: FROM dpp_transaction_headers_all headers
1499: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1500: 'AND EXISTS (SELECT dcca.Transaction_header_id
1501: FROM DPP_customer_claims_all dcca,
1502: DPP_TRANSACTION_LINES_GT dtga

Line 1578: FROM dpp_transaction_headers_all headers

1574: AND dcc.customer_inv_line_id = dtg.transaction_line_id
1575: AND nvl(dcc.reported_inventory,0) > 0
1576: AND nvl(dcc.cust_claim_amt,0) > 0
1577: AND nvl(dcc.customer_claim_created,''N'') = ''N'') LINES
1578: FROM dpp_transaction_headers_all headers
1579: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1580: 'AND EXISTS (SELECT dcca.Transaction_header_id
1581: FROM DPP_customer_claims_all dcca,
1582: DPP_TRANSACTION_LINES_GT dtga

Line 1617: FROM dpp_transaction_headers_all headers

1613: UOM
1614: FROM dpp_transaction_lines_all lines
1615: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1616: AND lines.price_change > 0 ) LINES
1617: FROM dpp_transaction_headers_all headers
1618: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1619: 'AND EXISTS (SELECT Transaction_header_id
1620: FROM dpp_transaction_lines_all
1621: WHERE price_change > 0

Line 1649: FROM dpp_transaction_headers_all headers

1645: CURSOR(select transaction_line_id,
1646: inventory_item_id
1647: FROM dpp_transaction_lines_all lines
1648: WHERE headers.Transaction_header_id = lines.Transaction_header_id) LINES
1649: FROM dpp_transaction_headers_all headers
1650: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1651: 'AND EXISTS (SELECT Transaction_header_id
1652: FROM dpp_transaction_lines_all
1653: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||')'