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.CSTPMRGL dependencies on CST_MARGIN_SUMMARY

Line 64: from CST_MARGIN_SUMMARY cms1 , CST_MARGIN_SUMMARY cms2

60: +--------------------------------------------------------------------*/
61:
62: Cursor upd_org_cogs is
63: select distinct cms1.rowid , cms2.org_id
64: from CST_MARGIN_SUMMARY cms1 , CST_MARGIN_SUMMARY cms2
65: where cms2.source in ('INVOICE' , 'RMA-INVOICE')
66: and cms2.legal_entity_id = cms1.legal_entity_id
67: and cms2.header_id = cms1.header_id /* Added for bug# 5098340 */
68: and cms2.order_number = cms1.order_number

Line 81: FROM cst_margin_summary

77: AND flow_type = 1); -- > dropship
78:
79: CURSOR sold_to_cust(l_build_id NUMBER, l_from_date DATE , l_to_date DATE ) is
80: SELECT rowid , customer_id
81: FROM cst_margin_summary
82: WHERE build_id = l_build_id
83: AND gl_date between l_from_date and l_to_date
84: AND customer_id is not null ;
85:

Line 151: | Delete from CST_MARGIN_SUMMARY for the given Legal Entity

147: -- DBMS_OUTPUT.PUT_LINE('l_from_date = ' || to_char(l_from_date));
148: -- DBMS_OUTPUT.PUT_LINE('l_to_date = ' || to_char(l_to_date));
149:
150: /*---------------------------------------------------------------+
151: | Delete from CST_MARGIN_SUMMARY for the given Legal Entity
152: +---------------------------------------------------------------*/
153:
154: BEGIN
155:

Line 160: DELETE from CST_MARGIN_SUMMARY

156: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
157: -- DBMS_OUTPUT.PUT_LINE('DELETE from TEMP.');
158: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
159:
160: DELETE from CST_MARGIN_SUMMARY
161: WHERE legal_entity_id = l_le_id
162: and gl_date between l_from_date and l_to_date;
163:
164: EXCEPTION

Line 268: | Insert into CST_MARGIN_SUMMARY for all the invoices booked

264:
265: EXIT WHEN all_ous%NOTFOUND;
266:
267: /*---------------------------------------------------------------+
268: | Insert into CST_MARGIN_SUMMARY for all the invoices booked
269: | against regular orders
270: +---------------------------------------------------------------*/
271:
272: l_stmt_id := 30;

Line 278: INSERT INTO CST_MARGIN_SUMMARY

274: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
275: -- DBMS_OUTPUT.PUT_LINE('INSERT into TEMP.');
276: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
277:
278: INSERT INTO CST_MARGIN_SUMMARY
279: (
280: build_id
281: ,source
282: ,row_type

Line 412: | Insert into CST_MARGIN_SUMMARY for IC-AR

408: AND mp.organization_id = sl_parent.ship_from_org_id
409: AND NVL(mp.process_enabled_flag, 'N') = 'N';
410:
411: /*---------------------------------------------------------------+
412: | Insert into CST_MARGIN_SUMMARY for IC-AR
413: +---------------------------------------------------------------*/
414:
415: l_stmt_id := 35;
416:

Line 421: INSERT INTO CST_MARGIN_SUMMARY

417: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
418: -- DBMS_OUTPUT.PUT_LINE('INSERT into TEMP.');
419: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
420:
421: INSERT INTO CST_MARGIN_SUMMARY
422: (
423: build_id
424: ,source
425: ,row_type

Line 568: INSERT INTO CST_MARGIN_SUMMARY

564:
565: -- Bug#2019804.Added to_char to fix Invalid number problem and also changed
566: -- where clause for performance viz . use of exist
567:
568: INSERT INTO CST_MARGIN_SUMMARY
569: (
570: build_id
571: ,source
572: ,row_type

Line 704: UPDATE CST_MARGIN_SUMMARY rma

700: +---------------------------------------------------------------*/
701:
702: l_stmt_id := 50;
703:
704: UPDATE CST_MARGIN_SUMMARY rma
705: SET (
706: parent_rowid ,
707: order_number,
708: header_id,

Line 788: INSERT INTO CST_MARGIN_SUMMARY

784: +---------------------------------------------------------------*/
785:
786: l_stmt_id := 80;
787:
788: INSERT INTO CST_MARGIN_SUMMARY
789: (
790: build_id
791: ,source
792: ,row_type

Line 868: /*+ no_merge index(temp, cst_margin_summary_n5 )... Hint suggested by ATANDON of the performance team

864: rct.CUSTOMER_TRX_ID,
865: rctl.CUSTOMER_TRX_LINE_ID
866: FROM
867: (
868: /*+ no_merge index(temp, cst_margin_summary_n5 )... Hint suggested by ATANDON of the performance team
869: Removed the Hint for perf 6310641 */
870: select *
871: from
872: CST_MARGIN_SUMMARY temp

Line 872: CST_MARGIN_SUMMARY temp

868: /*+ no_merge index(temp, cst_margin_summary_n5 )... Hint suggested by ATANDON of the performance team
869: Removed the Hint for perf 6310641 */
870: select *
871: from
872: CST_MARGIN_SUMMARY temp
873: where
874: temp.source = 'INVOICE'
875: and temp.org_id = l_ou_id
876: and temp.rowid in (select max(rowid) from cst_margin_summary t1

Line 876: and temp.rowid in (select max(rowid) from cst_margin_summary t1

872: CST_MARGIN_SUMMARY temp
873: where
874: temp.source = 'INVOICE'
875: and temp.org_id = l_ou_id
876: and temp.rowid in (select max(rowid) from cst_margin_summary t1
877: where t1.build_id = temp.build_id
878: and t1.source = 'INVOICE'
879: and t1.org_id = l_ou_id
880: and t1.header_id = temp.header_id

Line 905: from cst_margin_summary t2,

901: and rctl.previous_customer_trx_line_id = temp.CUSTOMER_TRX_LINE_ID
902: and rctl.previous_customer_trx_id = temp.customer_trx_id
903: and not exists
904: (select 'x'
905: from cst_margin_summary t2,
906: oe_order_lines_all oel
907: where t2.source = 'RMA-INVOICE'
908: and t2.build_id = temp.build_id
909: and t2.org_id = l_ou_id

Line 923: INSERT INTO CST_MARGIN_SUMMARY

919: +---------------------------------------------------------------*/
920:
921: l_stmt_id := 90;
922:
923: INSERT INTO CST_MARGIN_SUMMARY
924: (
925: build_id
926: ,source
927: ,row_type

Line 1101: INSERT INTO CST_MARGIN_SUMMARY

1097: +---------------------------------------------------------------*/
1098:
1099: l_stmt_id := 95;
1100:
1101: INSERT INTO CST_MARGIN_SUMMARY
1102: (
1103: build_id
1104: ,source
1105: ,row_type

Line 1209: INSERT INTO CST_MARGIN_SUMMARY

1205: +---------------------------------------------------------------*/
1206:
1207: l_stmt_id := 100;
1208:
1209: INSERT INTO CST_MARGIN_SUMMARY
1210: (
1211: build_id
1212: ,source
1213: ,row_type

Line 1327: UPDATE CST_MARGIN_SUMMARY rma

1323: +---------------------------------------------------------------*/
1324:
1325: l_stmt_id := 110;
1326:
1327: UPDATE CST_MARGIN_SUMMARY rma
1328: SET (
1329: parent_rowid ,
1330: order_number,
1331: header_id,

Line 1429: UPDATE CST_MARGIN_SUMMARY temp

1425: +---------------------------------------------------------------*/
1426:
1427: l_stmt_id := 140;
1428:
1429: UPDATE CST_MARGIN_SUMMARY temp
1430: SET territory_id =
1431: (SELECT territory_id
1432: FROM hz_cust_site_uses_all hcsua
1433: WHERE NVL(hcsua.org_id, -999) = NVL(l_ou_id, NVL(hcsua.org_id, -999))

Line 1446: UPDATE CST_MARGIN_SUMMARY temp

1442: +---------------------------------------------------------------*/
1443:
1444: l_stmt_id := 150;
1445:
1446: UPDATE CST_MARGIN_SUMMARY temp
1447: SET customer_class_code =
1448: (SELECT customer_class_code
1449: FROM hz_cust_accounts
1450: WHERE cust_account_id = temp.customer_id)

Line 1472: UPDATE CST_MARGIN_SUMMARY

1468: hz_parties hp
1469: WHERE hca.cust_account_id = l_cust_id
1470: AND hp.party_id = hca.party_id ;
1471:
1472: UPDATE CST_MARGIN_SUMMARY
1473: SET sold_to_customer_name = l_cust_name
1474: WHERE
1475: rowid = l_rowid ;
1476: END LOOP ;

Line 1485: UPDATE CST_MARGIN_SUMMARY temp

1481: +---------------------------------------------------------------*/
1482:
1483: l_stmt_id := 170;
1484:
1485: UPDATE CST_MARGIN_SUMMARY temp
1486: SET bill_to_customer_name =
1487: (SELECT SUBSTRB(hp.party_name,1,50)
1488: FROM hz_cust_accounts hca,
1489: hz_cust_site_uses_all hcsua,

Line 1511: UPDATE CST_MARGIN_SUMMARY temp

1507: +---------------------------------------------------------------*/
1508:
1509: l_stmt_id := 180;
1510:
1511: UPDATE CST_MARGIN_SUMMARY temp
1512: SET ship_to_customer_name =
1513: (SELECT SUBSTRB(hp.party_name,1,50)
1514: FROM hz_cust_accounts hca,
1515: hz_cust_site_uses_all hcsua,

Line 1544: update CST_MARGIN_SUMMARY

1540:
1541: /* Update the selling OUs for COGS incase where shipping OU is different from booking OU bug 2554225*/
1542:
1543: For cogs_rec in upd_org_cogs LOOP
1544: update CST_MARGIN_SUMMARY
1545: set org_id = cogs_rec.org_id
1546: where rowid = cogs_rec.rowid ;
1547: End Loop ;
1548: