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 418: | Insert into CST_MARGIN_SUMMARY for IC-AR

414: AND mp.organization_id(+) = sl_parent.ship_from_org_id
415: AND NVL(mp.process_enabled_flag, 'N') = 'N';
416:
417: /*---------------------------------------------------------------+
418: | Insert into CST_MARGIN_SUMMARY for IC-AR
419: +---------------------------------------------------------------*/
420:
421: l_stmt_id := 35;
422:

Line 427: INSERT INTO CST_MARGIN_SUMMARY

423: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
424: -- DBMS_OUTPUT.PUT_LINE('INSERT into TEMP.');
425: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
426:
427: INSERT INTO CST_MARGIN_SUMMARY
428: (
429: build_id
430: ,source
431: ,row_type

Line 582: INSERT INTO CST_MARGIN_SUMMARY

578:
579: -- Bug#2019804.Added to_char to fix Invalid number problem and also changed
580: -- where clause for performance viz . use of exist
581:
582: INSERT INTO CST_MARGIN_SUMMARY
583: (
584: build_id
585: ,source
586: ,row_type

Line 724: UPDATE CST_MARGIN_SUMMARY rma

720: +---------------------------------------------------------------*/
721:
722: l_stmt_id := 50;
723:
724: UPDATE CST_MARGIN_SUMMARY rma
725: SET (
726: parent_rowid ,
727: order_number,
728: header_id,

Line 808: INSERT INTO CST_MARGIN_SUMMARY

804: +---------------------------------------------------------------*/
805:
806: l_stmt_id := 80;
807:
808: INSERT INTO CST_MARGIN_SUMMARY
809: (
810: build_id
811: ,source
812: ,row_type

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

884: rct.CUSTOMER_TRX_ID,
885: rctl.CUSTOMER_TRX_LINE_ID
886: FROM
887: (
888: /*+ no_merge index(temp, cst_margin_summary_n5 )... Hint suggested by ATANDON of the performance team
889: Removed the Hint for perf 6310641 */
890: select *
891: from
892: CST_MARGIN_SUMMARY temp

Line 892: CST_MARGIN_SUMMARY temp

888: /*+ no_merge index(temp, cst_margin_summary_n5 )... Hint suggested by ATANDON of the performance team
889: Removed the Hint for perf 6310641 */
890: select *
891: from
892: CST_MARGIN_SUMMARY temp
893: where
894: temp.source = 'INVOICE'
895: and temp.org_id = l_ou_id
896: and temp.rowid in (select max(rowid) from cst_margin_summary t1

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

892: CST_MARGIN_SUMMARY temp
893: where
894: temp.source = 'INVOICE'
895: and temp.org_id = l_ou_id
896: and temp.rowid in (select max(rowid) from cst_margin_summary t1
897: where t1.build_id = temp.build_id
898: and t1.source = 'INVOICE'
899: and t1.org_id = l_ou_id
900: and t1.header_id = temp.header_id

Line 925: from cst_margin_summary t2,

921: and rctl.previous_customer_trx_line_id = temp.CUSTOMER_TRX_LINE_ID
922: and rctl.previous_customer_trx_id = temp.customer_trx_id
923: and not exists
924: (select 'x'
925: from cst_margin_summary t2,
926: oe_order_lines_all oel
927: where t2.source = 'RMA-INVOICE'
928: and t2.build_id = temp.build_id
929: and t2.org_id = l_ou_id

Line 943: INSERT INTO CST_MARGIN_SUMMARY

939: +---------------------------------------------------------------*/
940:
941: l_stmt_id := 90;
942:
943: INSERT INTO CST_MARGIN_SUMMARY
944: (
945: build_id
946: ,source
947: ,row_type

Line 1286: INSERT INTO CST_MARGIN_SUMMARY

1282: +---------------------------------------------------------------*/
1283:
1284: l_stmt_id := 95;
1285:
1286: INSERT INTO CST_MARGIN_SUMMARY
1287: (
1288: build_id
1289: ,source
1290: ,row_type

Line 1394: INSERT INTO CST_MARGIN_SUMMARY

1390: +---------------------------------------------------------------*/
1391:
1392: l_stmt_id := 100;
1393:
1394: INSERT INTO CST_MARGIN_SUMMARY
1395: (
1396: build_id
1397: ,source
1398: ,row_type

Line 1513: UPDATE CST_MARGIN_SUMMARY rma

1509: +---------------------------------------------------------------*/
1510:
1511: l_stmt_id := 110;
1512:
1513: UPDATE CST_MARGIN_SUMMARY rma
1514: SET (
1515: parent_rowid ,
1516: order_number,
1517: header_id,

Line 1615: UPDATE CST_MARGIN_SUMMARY temp

1611: +---------------------------------------------------------------*/
1612:
1613: l_stmt_id := 140;
1614:
1615: UPDATE CST_MARGIN_SUMMARY temp
1616: SET territory_id =
1617: (SELECT territory_id
1618: FROM hz_cust_site_uses_all hcsua
1619: WHERE NVL(hcsua.org_id, -999) = NVL(l_ou_id, NVL(hcsua.org_id, -999))

Line 1632: UPDATE CST_MARGIN_SUMMARY temp

1628: +---------------------------------------------------------------*/
1629:
1630: l_stmt_id := 150;
1631:
1632: UPDATE CST_MARGIN_SUMMARY temp
1633: SET customer_class_code =
1634: (SELECT customer_class_code
1635: FROM hz_cust_accounts
1636: WHERE cust_account_id = temp.customer_id)

Line 1658: UPDATE CST_MARGIN_SUMMARY

1654: hz_parties hp
1655: WHERE hca.cust_account_id = l_cust_id
1656: AND hp.party_id = hca.party_id ;
1657:
1658: UPDATE CST_MARGIN_SUMMARY
1659: SET sold_to_customer_name = l_cust_name
1660: WHERE
1661: rowid = l_rowid ;
1662: END LOOP ;

Line 1671: UPDATE CST_MARGIN_SUMMARY temp

1667: +---------------------------------------------------------------*/
1668:
1669: l_stmt_id := 170;
1670:
1671: UPDATE CST_MARGIN_SUMMARY temp
1672: SET bill_to_customer_name =
1673: (SELECT SUBSTRB(hp.party_name,1,50)
1674: FROM hz_cust_accounts hca,
1675: hz_cust_site_uses_all hcsua,

Line 1697: UPDATE CST_MARGIN_SUMMARY temp

1693: +---------------------------------------------------------------*/
1694:
1695: l_stmt_id := 180;
1696:
1697: UPDATE CST_MARGIN_SUMMARY temp
1698: SET ship_to_customer_name =
1699: (SELECT SUBSTRB(hp.party_name,1,50)
1700: FROM hz_cust_accounts hca,
1701: hz_cust_site_uses_all hcsua,

Line 1730: update CST_MARGIN_SUMMARY

1726:
1727: /* Update the selling OUs for COGS incase where shipping OU is different from booking OU bug 2554225*/
1728:
1729: For cogs_rec in upd_org_cogs LOOP
1730: update CST_MARGIN_SUMMARY
1731: set org_id = cogs_rec.org_id
1732: where rowid = cogs_rec.rowid ;
1733: End Loop ;
1734: