APPS.ECE_AR_TRANSACTION dependencies on RA_CUSTOMER_TRX_LINES

Line 876: FROM ra_customer_trx_lines rctl

872: l_Term_Relative_Amount /
873: l_Term_Base_Amount),
874: 0)
875: INTO Amount_Charges_Due
876: FROM ra_customer_trx_lines rctl
877: WHERE rctl.customer_trx_id = Get_Payment.Customer_Trx_ID
878: AND rctl.line_type = 'CHARGES';
879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN

Line 889: 'RA_CUSTOMER_TRX_LINES' );

885: xProgress,
886: 'INFO',
887: 'CHARGE AMOUNT DUE',
888: 'TABLE_NAME',
889: 'RA_CUSTOMER_TRX_LINES' );
890: END;
891:
892: ec_debug.pl ( 3, 'Amount_Charges_Due: ', Amount_Charges_Due );
893:

Line 907: FROM ra_customer_trx_lines

903: l_Term_Relative_Amount /
904: l_Term_Base_Amount),
905: l_Currency_Precision)
906: INTO l_Amount_Line_Items_Due
907: FROM ra_customer_trx_lines
908: WHERE customer_trx_id = Get_Payment.Customer_Trx_ID
909: AND line_type NOT IN ('TAX','FREIGHT','CHARGES');
910: EXCEPTION
911: WHEN NO_DATA_FOUND THEN

Line 920: 'RA_CUSTOMER_TRX_LINES' );

916: xProgress,
917: 'INFO',
918: 'LINE ITEM AMOUNT DUE',
919: 'TABLE_NAME',
920: 'RA_CUSTOMER_TRX_LINES' );
921: END;
922:
923: ec_debug.pl ( 3, 'l_Amount_Line_Items_Due: ', l_Amount_Line_Items_Due );
924:

Line 932: FROM ra_customer_trx_lines

928: l_Term_Relative_Amount /
929: l_Term_Base_Amount),
930: l_Currency_Precision)
931: INTO l_Amount_Charges_Due
932: FROM ra_customer_trx_lines
933: WHERE customer_trx_id = Get_Payment.Customer_Trx_ID
934: AND line_type = 'CHARGES';
935: EXCEPTION
936: WHEN NO_DATA_FOUND THEN

Line 945: 'RA_CUSTOMER_TRX_LINES' );

941: xProgress,
942: 'INFO',
943: 'CHARGE AMOUNT DUE',
944: 'TABLE_NAME',
945: 'RA_CUSTOMER_TRX_LINES' );
946: END;
947:
948: ec_debug.pl ( 3, 'l_Amount_Charges_Due: ', l_Amount_Charges_Due );
949:

Line 964: FROM ra_customer_trx_lines

960: xProgress := '2080-40';
961: BEGIN
962: SELECT SUM(extended_amount)
963: INTO l_Amount_Tax_Due
964: FROM ra_customer_trx_lines
965: WHERE customer_trx_id = Get_Payment.Customer_Trx_ID
966: AND line_type = 'TAX';
967: EXCEPTION
968: WHEN NO_DATA_FOUND THEN

Line 977: 'RA_CUSTOMER_TRX_LINES' );

973: xProgress,
974: 'INFO',
975: 'TAX AMOUNT DUE',
976: 'TABLE_NAME',
977: 'RA_CUSTOMER_TRX_LINES' );
978: END;
979:
980: ec_debug.pl (3, 'l_Amount_Tax_Due: ', l_Amount_Tax_Due);
981:

Line 986: FROM ra_customer_trx_lines

982: xProgress := '2090-40';
983: BEGIN
984: SELECT SUM(extended_amount)
985: INTO l_Amount_Freight_Due
986: FROM ra_customer_trx_lines
987: WHERE customer_trx_id = Get_Payment.Customer_Trx_ID
988: AND line_type = 'FREIGHT';
989: EXCEPTION
990: WHEN NO_DATA_FOUND THEN

Line 999: 'RA_CUSTOMER_TRX_LINES' );

995: xProgress,
996: 'INFO',
997: 'FREIGHT AMOUNT DUE',
998: 'TABLE_NAME',
999: 'RA_CUSTOMER_TRX_LINES' );
1000: END;
1001:
1002: ec_debug.pl (3, 'l_Amount_Freight_Due: ', l_Amount_Freight_Due);
1003:

Line 1020: FROM ra_customer_trx_lines

1016: l_Term_Relative_Amount /
1017: l_Term_Base_Amount),
1018: l_Currency_Precision)
1019: INTO l_Amount_Tax_Due
1020: FROM ra_customer_trx_lines
1021: WHERE customer_trx_id = Get_Payment.Customer_Trx_ID
1022: AND line_type = 'TAX';
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN

Line 1033: 'RA_CUSTOMER_TRX_LINES' );

1029: xProgress,
1030: 'INFO',
1031: 'TAX AMOUNT DUE',
1032: 'TABLE_NAME',
1033: 'RA_CUSTOMER_TRX_LINES' );
1034: END;
1035:
1036: ec_debug.pl ( 3, 'l_Amount_Tax_Due: ', l_Amount_Tax_Due );
1037:

Line 1045: FROM ra_customer_trx_lines

1041: l_Term_Relative_Amount /
1042: l_Term_Base_Amount),
1043: l_Currency_Precision)
1044: INTO l_Amount_Freight_Due
1045: FROM ra_customer_trx_lines
1046: WHERE customer_trx_id = Get_Payment.Customer_Trx_ID
1047: AND line_type = 'FREIGHT';
1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN

Line 1058: 'RA_CUSTOMER_TRX_LINES' );

1054: xProgress,
1055: 'INFO',
1056: 'FREIGHT AMOUNT DUE',
1057: 'TABLE_NAME',
1058: 'RA_CUSTOMER_TRX_LINES' );
1059: END;
1060:
1061: ec_debug.pl ( 3, 'l_Amount_Freight_Due: ', l_Amount_Freight_Due );
1062:

Line 3354: RA_CUSTOMER_TRX_LINES

3350: WSH_TRIPS
3351: WTP,
3352: WSH_DOCUMENT_INSTANCES
3353: WDI,
3354: RA_CUSTOMER_TRX_LINES
3355: RCTL
3356: WHERE
3357: TO_NUMBER(RCTL.INTERFACE_LINE_ATTRIBUTE6) =
3358: WDD.SOURCE_LINE_ID AND