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.ASO_SALES_CREDIT_PVT dependencies on CN_SCA_HEADERS_INTERFACE_GTT

Line 471: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

467: WHERE Quota_Flag = 'N';
468:
469: CURSOR C_Get_Total_Revenue (l_batch NUMBER) IS
470: SELECT SUM (NVL(A.Allocation_Percentage,0))
471: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
472: WHERE A.SCA_Batch_Id = l_batch
473: AND A.Revenue_Type = 'REVENUE'
474: AND B.SCA_Batch_Id = l_batch
475: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id

Line 480: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

476: AND B.Source_Line_Id IS NULL;
477:
478: CURSOR C_Get_Line_Revenue (l_batch NUMBER, l_line_id NUMBER) IS
479: SELECT SUM (NVL(A.Allocation_Percentage,0))
480: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
481: WHERE A.SCA_Batch_Id = l_batch
482: AND A.Revenue_Type = 'REVENUE'
483: AND B.SCA_Batch_Id = l_batch
484: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id

Line 489: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

485: AND B.Source_Line_Id = l_line_id;
486:
487: CURSOR C_Get_Hdr_Total (l_batch NUMBER) IS
488: SELECT SUM (NVL(Allocation_Percentage,0))
489: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
490: WHERE A.SCA_Batch_Id = l_batch
491: AND B.SCA_Batch_Id = l_batch
492: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id
493: AND B.Source_Line_Id IS NULL;

Line 497: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

493: AND B.Source_Line_Id IS NULL;
494:
495: CURSOR C_Get_Line_Total (l_batch NUMBER) IS
496: SELECT SUM (NVL(Allocation_Percentage,0))
497: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
498: WHERE A.SCA_Batch_Id = l_batch
499: AND B.SCA_Batch_Id = l_batch
500: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id
501: AND B.Source_Line_Id IS NOT NULL;

Line 526: FROM CN_SCA_HEADERS_INTERFACE_GTT;

522: WHERE Quote_Header_Id = l_qte_hdr;
523:
524: CURSOR C_Hd_Inter IS
525: SELECT Credit_Rule_Id, Process_Status
526: FROM CN_SCA_HEADERS_INTERFACE_GTT;
527:
528: C_Acct_Rec C_Get_Acct_Info%ROWTYPE;
529: C_Party_Rec C_Get_Party_Info%ROWTYPE;
530: C_Party_Site_Rec C_Get_Party_Site_Info%ROWTYPE;

Line 560: DELETE FROM CN_SCA_HEADERS_INTERFACE_GTT;

556:
557: -- Truncate temp tables
558: DELETE FROM CN_SCA_LINES_INTERFACE_GTT;
559:
560: DELETE FROM CN_SCA_HEADERS_INTERFACE_GTT;
561:
562: DELETE FROM CN_SCA_LINES_OUTPUT_GTT;
563:
564: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 597: -- Populate CN_SCA_HEADERS_INTERFACE_GTT with header info

593: aso_debug_pub.add('Get_Credits: C_Party_Site_Rec.County: '||C_Party_Site_Rec.County,1,'N');
594: aso_debug_pub.add('Get_Credits: p_qte_header_rec.Marketing_Source_Code_Id: '||p_qte_header_rec.Marketing_Source_Code_Id,1,'N');
595: aso_debug_pub.add('Get_Credits: p_qte_header_rec.Sales_Channel_Code: '||p_qte_header_rec.Sales_Channel_Code,1,'N');
596: END IF;
597: -- Populate CN_SCA_HEADERS_INTERFACE_GTT with header info
598: INSERT INTO CN_SCA_HEADERS_INTERFACE_GTT (
599: SCA_HEADERS_INTERFACE_ID,
600: SCA_BATCH_ID,
601: TRANSACTION_SOURCE,

Line 598: INSERT INTO CN_SCA_HEADERS_INTERFACE_GTT (

594: aso_debug_pub.add('Get_Credits: p_qte_header_rec.Marketing_Source_Code_Id: '||p_qte_header_rec.Marketing_Source_Code_Id,1,'N');
595: aso_debug_pub.add('Get_Credits: p_qte_header_rec.Sales_Channel_Code: '||p_qte_header_rec.Sales_Channel_Code,1,'N');
596: END IF;
597: -- Populate CN_SCA_HEADERS_INTERFACE_GTT with header info
598: INSERT INTO CN_SCA_HEADERS_INTERFACE_GTT (
599: SCA_HEADERS_INTERFACE_ID,
600: SCA_BATCH_ID,
601: TRANSACTION_SOURCE,
602: SOURCE_TYPE,

Line 622: VALUES ( CN_SCA_HEADERS_INTERFACE_GTT_S.NextVal,

618: ATTRIBUTE21,
619: ATTRIBUTE22,
620: ATTRIBUTE23,
621: ATTRIBUTE24 )
622: VALUES ( CN_SCA_HEADERS_INTERFACE_GTT_S.NextVal,
623: l_batch_id,
624: 'QOT',
625: NULL,
626: p_qte_header_rec.Quote_Header_Id,

Line 651: -- Populate CN_SCA_HEADERS_INTERFACE_GTT with lines info

647:
648: IF aso_debug_pub.g_debug_flag = 'Y' THEN
649: aso_debug_pub.add('Get_Credits: Before insert line info ',1,'N');
650: END IF;
651: -- Populate CN_SCA_HEADERS_INTERFACE_GTT with lines info
652: INSERT INTO CN_SCA_HEADERS_INTERFACE_GTT (
653: SCA_HEADERS_INTERFACE_ID,
654: SCA_BATCH_ID,
655: TRANSACTION_SOURCE,

Line 652: INSERT INTO CN_SCA_HEADERS_INTERFACE_GTT (

648: IF aso_debug_pub.g_debug_flag = 'Y' THEN
649: aso_debug_pub.add('Get_Credits: Before insert line info ',1,'N');
650: END IF;
651: -- Populate CN_SCA_HEADERS_INTERFACE_GTT with lines info
652: INSERT INTO CN_SCA_HEADERS_INTERFACE_GTT (
653: SCA_HEADERS_INTERFACE_ID,
654: SCA_BATCH_ID,
655: TRANSACTION_SOURCE,
656: SOURCE_TYPE,

Line 679: SELECT CN_SCA_HEADERS_INTERFACE_GTT_S.NextVal,

675: ATTRIBUTE21,
676: ATTRIBUTE22,
677: ATTRIBUTE23,
678: ATTRIBUTE24 )
679: SELECT CN_SCA_HEADERS_INTERFACE_GTT_S.NextVal,
680: l_batch_id,
681: 'QOT',
682: NULL,
683: p_qte_header_rec.Quote_Header_Id,

Line 727: FROM ASO_QUOTE_ACCESSES A, CN_SCA_HEADERS_INTERFACE_GTT B

723: l_batch_id,
724: A.Resource_Id,
725: A.Role_Id,
726: p_qte_header_rec.quote_header_id
727: FROM ASO_QUOTE_ACCESSES A, CN_SCA_HEADERS_INTERFACE_GTT B
728: WHERE A.Quote_Number = p_qte_header_rec.Quote_Number
729: AND A.Role_Id IS NOT NULL
730: AND EXISTS
731: ( SELECT C.Resource_Id

Line 748: select count(*) into l_dumb from CN_SCA_HEADERS_INTERFACE_GTT;

744: */
745: --Commented Code End Yogeshwar (MOAC)
746:
747: IF aso_debug_pub.g_debug_flag = 'Y' THEN
748: select count(*) into l_dumb from CN_SCA_HEADERS_INTERFACE_GTT;
749: aso_debug_pub.add('Get_Credits: l_headers: '||l_dumb,1,'N');
750: IF l_dumb > 0 THEN
751: FOR C_Hd_Rec IN C_Hd_Inter LOOP
752: aso_debug_pub.add('Get_Credits: tmp credit_rule_id: '||C_Hd_Rec.credit_rule_id,1,'N');

Line 875: CN_SCA_HEADERS_INTERFACE_GTT B,

871: Decode(A.Revenue_Type, 'REVENUE', l_quota_id,l_non_quota_id),
872: 'Y',
873: B.Credit_Rule_Id
874: FROM CN_SCA_LINES_OUTPUT_GTT A,
875: CN_SCA_HEADERS_INTERFACE_GTT B,
876: ASO_QUOTE_ACCESSES C
877: WHERE A.SCA_Batch_Id = l_batch_id
878: AND B.SCA_Batch_Id = l_batch_id
879: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id

Line 1000: CN_SCA_HEADERS_INTERFACE_GTT B,

996: Decode(A.Revenue_Type, 'REVENUE', l_quota_id,l_non_quota_id),
997: 'Y',
998: B.Credit_Rule_Id
999: FROM CN_SCA_LINES_OUTPUT_GTT A,
1000: CN_SCA_HEADERS_INTERFACE_GTT B,
1001: ASO_QUOTE_ACCESSES C
1002: WHERE A.SCA_Batch_Id = l_batch_id
1003: AND B.SCA_Batch_Id = l_batch_id
1004: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id