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.CST_ACCRUAL_REC_PVT dependencies on FND_GLOBAL

Line 81: FND_GLOBAL.USER_ID, --last_updated_by,

77: SELECT
78: t.org_id,
79: t.accrual_account_id,
80: sysdate, --last_update_date,
81: FND_GLOBAL.USER_ID, --last_updated_by,
82: FND_GLOBAL.USER_ID, --last_update_login,
83: sysdate, --creation_date,
84: FND_GLOBAL.USER_ID, --created_by,
85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 82: FND_GLOBAL.USER_ID, --last_update_login,

78: t.org_id,
79: t.accrual_account_id,
80: sysdate, --last_update_date,
81: FND_GLOBAL.USER_ID, --last_updated_by,
82: FND_GLOBAL.USER_ID, --last_update_login,
83: sysdate, --creation_date,
84: FND_GLOBAL.USER_ID, --created_by,
85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
86: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 84: FND_GLOBAL.USER_ID, --created_by,

80: sysdate, --last_update_date,
81: FND_GLOBAL.USER_ID, --last_updated_by,
82: FND_GLOBAL.USER_ID, --last_update_login,
83: sysdate, --creation_date,
84: FND_GLOBAL.USER_ID, --created_by,
85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
86: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
87: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
88: sysdate

Line 85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

81: FND_GLOBAL.USER_ID, --last_updated_by,
82: FND_GLOBAL.USER_ID, --last_update_login,
83: sysdate, --creation_date,
84: FND_GLOBAL.USER_ID, --created_by,
85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
86: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
87: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
88: sysdate
89: FROM

Line 86: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

82: FND_GLOBAL.USER_ID, --last_update_login,
83: sysdate, --creation_date,
84: FND_GLOBAL.USER_ID, --created_by,
85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
86: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
87: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
88: sysdate
89: FROM
90: (select distinct p_ou_id org_id, paat.accrual_account_id accrual_account_id

Line 87: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

83: sysdate, --creation_date,
84: FND_GLOBAL.USER_ID, --created_by,
85: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
86: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
87: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
88: sysdate
89: FROM
90: (select distinct p_ou_id org_id, paat.accrual_account_id accrual_account_id
91: from po_accrual_accounts_temp_all paat

Line 942: FND_GLOBAL.USER_ID, --last_updated_by,

938: c_wo_rec.vendor_id,
939: l_le_id,
940: p_ou_id,
941: sysdate, --last_update_date,
942: FND_GLOBAL.USER_ID, --last_updated_by,
943: FND_GLOBAL.USER_ID, --last_update_login,
944: sysdate, --creation_date,
945: FND_GLOBAL.USER_ID, --created_by,
946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 943: FND_GLOBAL.USER_ID, --last_update_login,

939: l_le_id,
940: p_ou_id,
941: sysdate, --last_update_date,
942: FND_GLOBAL.USER_ID, --last_updated_by,
943: FND_GLOBAL.USER_ID, --last_update_login,
944: sysdate, --creation_date,
945: FND_GLOBAL.USER_ID, --created_by,
946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 945: FND_GLOBAL.USER_ID, --created_by,

941: sysdate, --last_update_date,
942: FND_GLOBAL.USER_ID, --last_updated_by,
943: FND_GLOBAL.USER_ID, --last_update_login,
944: sysdate, --creation_date,
945: FND_GLOBAL.USER_ID, --created_by,
946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
948: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
949: sysdate -- program_update_date

Line 946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

942: FND_GLOBAL.USER_ID, --last_updated_by,
943: FND_GLOBAL.USER_ID, --last_update_login,
944: sysdate, --creation_date,
945: FND_GLOBAL.USER_ID, --created_by,
946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
948: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
949: sysdate -- program_update_date
950: )

Line 947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

943: FND_GLOBAL.USER_ID, --last_update_login,
944: sysdate, --creation_date,
945: FND_GLOBAL.USER_ID, --created_by,
946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
948: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
949: sysdate -- program_update_date
950: )
951: into cst_write_off_details

Line 948: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

944: sysdate, --creation_date,
945: FND_GLOBAL.USER_ID, --created_by,
946: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
947: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
948: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
949: sysdate -- program_update_date
950: )
951: into cst_write_off_details
952: (

Line 996: FND_GLOBAL.USER_ID, --last_updated_by,

992: c_wo_rec.inventory_transaction_id,
993: c_wo_rec.inventory_organization_id,
994: p_ou_id,
995: sysdate, --last_update_date,
996: FND_GLOBAL.USER_ID, --last_updated_by,
997: FND_GLOBAL.USER_ID, --last_update_login,
998: sysdate, --creation_date,
999: FND_GLOBAL.USER_ID, --created_by,
1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 997: FND_GLOBAL.USER_ID, --last_update_login,

993: c_wo_rec.inventory_organization_id,
994: p_ou_id,
995: sysdate, --last_update_date,
996: FND_GLOBAL.USER_ID, --last_updated_by,
997: FND_GLOBAL.USER_ID, --last_update_login,
998: sysdate, --creation_date,
999: FND_GLOBAL.USER_ID, --created_by,
1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1001: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 999: FND_GLOBAL.USER_ID, --created_by,

995: sysdate, --last_update_date,
996: FND_GLOBAL.USER_ID, --last_updated_by,
997: FND_GLOBAL.USER_ID, --last_update_login,
998: sysdate, --creation_date,
999: FND_GLOBAL.USER_ID, --created_by,
1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1001: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1002: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1003: sysdate, --program_update_date,

Line 1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

996: FND_GLOBAL.USER_ID, --last_updated_by,
997: FND_GLOBAL.USER_ID, --last_update_login,
998: sysdate, --creation_date,
999: FND_GLOBAL.USER_ID, --created_by,
1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1001: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1002: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1003: sysdate, --program_update_date,
1004: c_wo_rec.ae_header_id,

Line 1001: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

997: FND_GLOBAL.USER_ID, --last_update_login,
998: sysdate, --creation_date,
999: FND_GLOBAL.USER_ID, --created_by,
1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1001: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1002: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1003: sysdate, --program_update_date,
1004: c_wo_rec.ae_header_id,
1005: c_wo_rec.ae_line_num

Line 1002: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

998: sysdate, --creation_date,
999: FND_GLOBAL.USER_ID, --created_by,
1000: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1001: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1002: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1003: sysdate, --program_update_date,
1004: c_wo_rec.ae_header_id,
1005: c_wo_rec.ae_line_num
1006: )

Line 1292: FND_GLOBAL.USER_ID, --last_updated_by,

1288: capr.write_off_id,
1289: capr.inventory_organization_id,
1290: capr.operating_unit_id,
1291: sysdate, --last_update_date,
1292: FND_GLOBAL.USER_ID, --last_updated_by,
1293: FND_GLOBAL.USER_ID, --last_update_login,
1294: sysdate, --creation_date,
1295: FND_GLOBAL.USER_ID, --created_by,
1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1293: FND_GLOBAL.USER_ID, --last_update_login,

1289: capr.inventory_organization_id,
1290: capr.operating_unit_id,
1291: sysdate, --last_update_date,
1292: FND_GLOBAL.USER_ID, --last_updated_by,
1293: FND_GLOBAL.USER_ID, --last_update_login,
1294: sysdate, --creation_date,
1295: FND_GLOBAL.USER_ID, --created_by,
1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1297: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1295: FND_GLOBAL.USER_ID, --created_by,

1291: sysdate, --last_update_date,
1292: FND_GLOBAL.USER_ID, --last_updated_by,
1293: FND_GLOBAL.USER_ID, --last_update_login,
1294: sysdate, --creation_date,
1295: FND_GLOBAL.USER_ID, --created_by,
1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1297: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1298: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1299: sysdate, --program_update_date,

Line 1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1292: FND_GLOBAL.USER_ID, --last_updated_by,
1293: FND_GLOBAL.USER_ID, --last_update_login,
1294: sysdate, --creation_date,
1295: FND_GLOBAL.USER_ID, --created_by,
1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1297: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1298: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1299: sysdate, --program_update_date,
1300: capr.ae_header_id,

Line 1297: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1293: FND_GLOBAL.USER_ID, --last_update_login,
1294: sysdate, --creation_date,
1295: FND_GLOBAL.USER_ID, --created_by,
1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1297: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1298: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1299: sysdate, --program_update_date,
1300: capr.ae_header_id,
1301: capr.ae_line_num

Line 1298: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1294: sysdate, --creation_date,
1295: FND_GLOBAL.USER_ID, --created_by,
1296: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1297: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1298: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1299: sysdate, --program_update_date,
1300: capr.ae_header_id,
1301: capr.ae_line_num
1302: from cst_ap_po_reconciliation capr

Line 1468: FND_GLOBAL.USER_ID, --last_updated_by,

1464: c_wo_rec.inventory_item_id,
1465: c_wo_rec.vendor_id,
1466: p_ou_id,
1467: sysdate, --last_update_date,
1468: FND_GLOBAL.USER_ID, --last_updated_by,
1469: FND_GLOBAL.USER_ID, --last_update_login,
1470: sysdate, --creation_date,
1471: FND_GLOBAL.USER_ID, --created_by,
1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1469: FND_GLOBAL.USER_ID, --last_update_login,

1465: c_wo_rec.vendor_id,
1466: p_ou_id,
1467: sysdate, --last_update_date,
1468: FND_GLOBAL.USER_ID, --last_updated_by,
1469: FND_GLOBAL.USER_ID, --last_update_login,
1470: sysdate, --creation_date,
1471: FND_GLOBAL.USER_ID, --created_by,
1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1473: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1471: FND_GLOBAL.USER_ID, --created_by,

1467: sysdate, --last_update_date,
1468: FND_GLOBAL.USER_ID, --last_updated_by,
1469: FND_GLOBAL.USER_ID, --last_update_login,
1470: sysdate, --creation_date,
1471: FND_GLOBAL.USER_ID, --created_by,
1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1473: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1474: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1475: sysdate --program_update_date

Line 1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1468: FND_GLOBAL.USER_ID, --last_updated_by,
1469: FND_GLOBAL.USER_ID, --last_update_login,
1470: sysdate, --creation_date,
1471: FND_GLOBAL.USER_ID, --created_by,
1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1473: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1474: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1475: sysdate --program_update_date
1476: );

Line 1473: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1469: FND_GLOBAL.USER_ID, --last_update_login,
1470: sysdate, --creation_date,
1471: FND_GLOBAL.USER_ID, --created_by,
1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1473: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1474: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1475: sysdate --program_update_date
1476: );
1477: --}

Line 1474: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1470: sysdate, --creation_date,
1471: FND_GLOBAL.USER_ID, --created_by,
1472: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1473: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1474: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1475: sysdate --program_update_date
1476: );
1477: --}
1478: end loop; /* for c_wo_rec in c_wo(p_ou_id) */

Line 1925: FND_GLOBAL.USER_ID, --last_updated_by,

1921: c_wo_rec.vendor_id,
1922: c_wo_rec.legal_entity_id,
1923: c_wo_rec.operating_unit_id,
1924: sysdate, --last_update_date,
1925: FND_GLOBAL.USER_ID, --last_updated_by,
1926: FND_GLOBAL.USER_ID, --last_update_login,
1927: sysdate, --creation_date,
1928: FND_GLOBAL.USER_ID, --created_by,
1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1926: FND_GLOBAL.USER_ID, --last_update_login,

1922: c_wo_rec.legal_entity_id,
1923: c_wo_rec.operating_unit_id,
1924: sysdate, --last_update_date,
1925: FND_GLOBAL.USER_ID, --last_updated_by,
1926: FND_GLOBAL.USER_ID, --last_update_login,
1927: sysdate, --creation_date,
1928: FND_GLOBAL.USER_ID, --created_by,
1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1930: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1928: FND_GLOBAL.USER_ID, --created_by,

1924: sysdate, --last_update_date,
1925: FND_GLOBAL.USER_ID, --last_updated_by,
1926: FND_GLOBAL.USER_ID, --last_update_login,
1927: sysdate, --creation_date,
1928: FND_GLOBAL.USER_ID, --created_by,
1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1930: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1931: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1932: sysdate --program_update_date

Line 1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1925: FND_GLOBAL.USER_ID, --last_updated_by,
1926: FND_GLOBAL.USER_ID, --last_update_login,
1927: sysdate, --creation_date,
1928: FND_GLOBAL.USER_ID, --created_by,
1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1930: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1931: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1932: sysdate --program_update_date
1933: );

Line 1930: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1926: FND_GLOBAL.USER_ID, --last_update_login,
1927: sysdate, --creation_date,
1928: FND_GLOBAL.USER_ID, --created_by,
1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1930: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1931: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1932: sysdate --program_update_date
1933: );
1934:

Line 1931: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1927: sysdate, --creation_date,
1928: FND_GLOBAL.USER_ID, --created_by,
1929: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1930: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1931: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1932: sysdate --program_update_date
1933: );
1934:
1935: l_stmt_num := 25;

Line 1988: FND_GLOBAL.USER_ID, --last_updated_by,

1984: cwod.write_off_transaction_id,
1985: cwod.inventory_organization_id,
1986: cwod.operating_unit_id,
1987: sysdate, --last_update_date,
1988: FND_GLOBAL.USER_ID, --last_updated_by,
1989: FND_GLOBAL.USER_ID, --last_update_login,
1990: sysdate, --creation_date,
1991: FND_GLOBAL.USER_ID, --created_by,
1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1989: FND_GLOBAL.USER_ID, --last_update_login,

1985: cwod.inventory_organization_id,
1986: cwod.operating_unit_id,
1987: sysdate, --last_update_date,
1988: FND_GLOBAL.USER_ID, --last_updated_by,
1989: FND_GLOBAL.USER_ID, --last_update_login,
1990: sysdate, --creation_date,
1991: FND_GLOBAL.USER_ID, --created_by,
1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1993: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1991: FND_GLOBAL.USER_ID, --created_by,

1987: sysdate, --last_update_date,
1988: FND_GLOBAL.USER_ID, --last_updated_by,
1989: FND_GLOBAL.USER_ID, --last_update_login,
1990: sysdate, --creation_date,
1991: FND_GLOBAL.USER_ID, --created_by,
1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1993: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1994: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1995: sysdate, --program_update_date,

Line 1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1988: FND_GLOBAL.USER_ID, --last_updated_by,
1989: FND_GLOBAL.USER_ID, --last_update_login,
1990: sysdate, --creation_date,
1991: FND_GLOBAL.USER_ID, --created_by,
1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1993: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1994: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1995: sysdate, --program_update_date,
1996: cwod.ae_header_id,

Line 1993: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1989: FND_GLOBAL.USER_ID, --last_update_login,
1990: sysdate, --creation_date,
1991: FND_GLOBAL.USER_ID, --created_by,
1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1993: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1994: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1995: sysdate, --program_update_date,
1996: cwod.ae_header_id,
1997: cwod.ae_line_num

Line 1994: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1990: sysdate, --creation_date,
1991: FND_GLOBAL.USER_ID, --created_by,
1992: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1993: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1994: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1995: sysdate, --program_update_date,
1996: cwod.ae_header_id,
1997: cwod.ae_line_num
1998: from cst_write_off_details cwod

Line 2061: FND_GLOBAL.USER_ID, --last_updated_by,

2057: cwo.vendor_id,
2058: cwod.inventory_organization_id,
2059: cwod.operating_unit_id,
2060: sysdate, --last_update_date,
2061: FND_GLOBAL.USER_ID, --last_updated_by,
2062: FND_GLOBAL.USER_ID, --last_update_login,
2063: sysdate, --creation_date,
2064: FND_GLOBAL.USER_ID, --created_by,
2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2062: FND_GLOBAL.USER_ID, --last_update_login,

2058: cwod.inventory_organization_id,
2059: cwod.operating_unit_id,
2060: sysdate, --last_update_date,
2061: FND_GLOBAL.USER_ID, --last_updated_by,
2062: FND_GLOBAL.USER_ID, --last_update_login,
2063: sysdate, --creation_date,
2064: FND_GLOBAL.USER_ID, --created_by,
2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2066: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2064: FND_GLOBAL.USER_ID, --created_by,

2060: sysdate, --last_update_date,
2061: FND_GLOBAL.USER_ID, --last_updated_by,
2062: FND_GLOBAL.USER_ID, --last_update_login,
2063: sysdate, --creation_date,
2064: FND_GLOBAL.USER_ID, --created_by,
2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2066: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2067: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2068: sysdate, --program_update_date,

Line 2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2061: FND_GLOBAL.USER_ID, --last_updated_by,
2062: FND_GLOBAL.USER_ID, --last_update_login,
2063: sysdate, --creation_date,
2064: FND_GLOBAL.USER_ID, --created_by,
2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2066: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2067: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2068: sysdate, --program_update_date,
2069: cwod.ae_header_id,

Line 2066: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2062: FND_GLOBAL.USER_ID, --last_update_login,
2063: sysdate, --creation_date,
2064: FND_GLOBAL.USER_ID, --created_by,
2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2066: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2067: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2068: sysdate, --program_update_date,
2069: cwod.ae_header_id,
2070: cwod.ae_line_num

Line 2067: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2063: sysdate, --creation_date,
2064: FND_GLOBAL.USER_ID, --created_by,
2065: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2066: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2067: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2068: sysdate, --program_update_date,
2069: cwod.ae_header_id,
2070: cwod.ae_line_num
2071: from cst_write_off_details cwod,

Line 2150: FND_GLOBAL.USER_ID, --last_updated_by,

2146: cwod.write_off_transaction_id,
2147: cwod.inventory_organization_id,
2148: cwod.operating_unit_id,
2149: sysdate, --last_update_date,
2150: FND_GLOBAL.USER_ID, --last_updated_by,
2151: FND_GLOBAL.USER_ID, --last_update_login,
2152: sysdate, --creation_date,
2153: FND_GLOBAL.USER_ID, --created_by,
2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2151: FND_GLOBAL.USER_ID, --last_update_login,

2147: cwod.inventory_organization_id,
2148: cwod.operating_unit_id,
2149: sysdate, --last_update_date,
2150: FND_GLOBAL.USER_ID, --last_updated_by,
2151: FND_GLOBAL.USER_ID, --last_update_login,
2152: sysdate, --creation_date,
2153: FND_GLOBAL.USER_ID, --created_by,
2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2155: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2153: FND_GLOBAL.USER_ID, --created_by,

2149: sysdate, --last_update_date,
2150: FND_GLOBAL.USER_ID, --last_updated_by,
2151: FND_GLOBAL.USER_ID, --last_update_login,
2152: sysdate, --creation_date,
2153: FND_GLOBAL.USER_ID, --created_by,
2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2155: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2156: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2157: sysdate, --program_update_date,

Line 2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2150: FND_GLOBAL.USER_ID, --last_updated_by,
2151: FND_GLOBAL.USER_ID, --last_update_login,
2152: sysdate, --creation_date,
2153: FND_GLOBAL.USER_ID, --created_by,
2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2155: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2156: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2157: sysdate, --program_update_date,
2158: cwod.ae_header_id,

Line 2155: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2151: FND_GLOBAL.USER_ID, --last_update_login,
2152: sysdate, --creation_date,
2153: FND_GLOBAL.USER_ID, --created_by,
2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2155: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2156: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2157: sysdate, --program_update_date,
2158: cwod.ae_header_id,
2159: cwod.ae_line_num

Line 2156: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2152: sysdate, --creation_date,
2153: FND_GLOBAL.USER_ID, --created_by,
2154: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2155: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2156: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2157: sysdate, --program_update_date,
2158: cwod.ae_header_id,
2159: cwod.ae_line_num
2160: from cst_write_offs cwo,

Line 2209: FND_GLOBAL.USER_ID, --last_updated_by,

2205: cwo.transaction_type_code,
2206: cwo.write_off_id,
2207: cwo.operating_unit_id,
2208: sysdate, --last_update_date,
2209: FND_GLOBAL.USER_ID, --last_updated_by,
2210: FND_GLOBAL.USER_ID, --last_update_login,
2211: sysdate, --creation_date,
2212: FND_GLOBAL.USER_ID, --created_by,
2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2210: FND_GLOBAL.USER_ID, --last_update_login,

2206: cwo.write_off_id,
2207: cwo.operating_unit_id,
2208: sysdate, --last_update_date,
2209: FND_GLOBAL.USER_ID, --last_updated_by,
2210: FND_GLOBAL.USER_ID, --last_update_login,
2211: sysdate, --creation_date,
2212: FND_GLOBAL.USER_ID, --created_by,
2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2212: FND_GLOBAL.USER_ID, --created_by,

2208: sysdate, --last_update_date,
2209: FND_GLOBAL.USER_ID, --last_updated_by,
2210: FND_GLOBAL.USER_ID, --last_update_login,
2211: sysdate, --creation_date,
2212: FND_GLOBAL.USER_ID, --created_by,
2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2215: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2216: sysdate --program_update_date

Line 2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2209: FND_GLOBAL.USER_ID, --last_updated_by,
2210: FND_GLOBAL.USER_ID, --last_update_login,
2211: sysdate, --creation_date,
2212: FND_GLOBAL.USER_ID, --created_by,
2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2215: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2216: sysdate --program_update_date
2217: from cst_write_offs cwo

Line 2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2210: FND_GLOBAL.USER_ID, --last_update_login,
2211: sysdate, --creation_date,
2212: FND_GLOBAL.USER_ID, --created_by,
2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2215: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2216: sysdate --program_update_date
2217: from cst_write_offs cwo
2218: where cwo.write_off_id in (c_wo_rec.l_wo_id, c_wo_rec.l_rev_id)

Line 2215: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2211: sysdate, --creation_date,
2212: FND_GLOBAL.USER_ID, --created_by,
2213: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2214: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2215: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2216: sysdate --program_update_date
2217: from cst_write_offs cwo
2218: where cwo.write_off_id in (c_wo_rec.l_wo_id, c_wo_rec.l_rev_id)
2219: and cwo.po_distribution_id = c_wo_rec.po_distribution_id

Line 2267: FND_GLOBAL.USER_ID, --last_updated_by,

2263: cwo.vendor_id,
2264: cwo.destination_type_code,
2265: cwo.operating_unit_id,
2266: sysdate, --last_update_date,
2267: FND_GLOBAL.USER_ID, --last_updated_by,
2268: FND_GLOBAL.USER_ID, --last_update_login,
2269: sysdate, --creation_date,
2270: FND_GLOBAL.USER_ID, --created_by,
2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2268: FND_GLOBAL.USER_ID, --last_update_login,

2264: cwo.destination_type_code,
2265: cwo.operating_unit_id,
2266: sysdate, --last_update_date,
2267: FND_GLOBAL.USER_ID, --last_updated_by,
2268: FND_GLOBAL.USER_ID, --last_update_login,
2269: sysdate, --creation_date,
2270: FND_GLOBAL.USER_ID, --created_by,
2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2270: FND_GLOBAL.USER_ID, --created_by,

2266: sysdate, --last_update_date,
2267: FND_GLOBAL.USER_ID, --last_updated_by,
2268: FND_GLOBAL.USER_ID, --last_update_login,
2269: sysdate, --creation_date,
2270: FND_GLOBAL.USER_ID, --created_by,
2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2274: sysdate --program_update_date

Line 2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2267: FND_GLOBAL.USER_ID, --last_updated_by,
2268: FND_GLOBAL.USER_ID, --last_update_login,
2269: sysdate, --creation_date,
2270: FND_GLOBAL.USER_ID, --created_by,
2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2274: sysdate --program_update_date
2275: from cst_ap_po_reconciliation capr,

Line 2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2268: FND_GLOBAL.USER_ID, --last_update_login,
2269: sysdate, --creation_date,
2270: FND_GLOBAL.USER_ID, --created_by,
2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2274: sysdate --program_update_date
2275: from cst_ap_po_reconciliation capr,
2276: cst_write_offs cwo

Line 2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2269: sysdate, --creation_date,
2270: FND_GLOBAL.USER_ID, --created_by,
2271: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2272: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2273: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2274: sysdate --program_update_date
2275: from cst_ap_po_reconciliation capr,
2276: cst_write_offs cwo
2277: where cwo.write_off_id = c_wo_rec.l_wo_id

Line 2382: FND_GLOBAL.USER_ID, --last_updated_by,

2378: cwo.transaction_type_code,
2379: cwo.write_off_id,
2380: cwo.operating_unit_id,
2381: sysdate, --last_update_date,
2382: FND_GLOBAL.USER_ID, --last_updated_by,
2383: FND_GLOBAL.USER_ID, --last_update_login,
2384: sysdate, --creation_date,
2385: FND_GLOBAL.USER_ID, --created_by,
2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2383: FND_GLOBAL.USER_ID, --last_update_login,

2379: cwo.write_off_id,
2380: cwo.operating_unit_id,
2381: sysdate, --last_update_date,
2382: FND_GLOBAL.USER_ID, --last_updated_by,
2383: FND_GLOBAL.USER_ID, --last_update_login,
2384: sysdate, --creation_date,
2385: FND_GLOBAL.USER_ID, --created_by,
2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2385: FND_GLOBAL.USER_ID, --created_by,

2381: sysdate, --last_update_date,
2382: FND_GLOBAL.USER_ID, --last_updated_by,
2383: FND_GLOBAL.USER_ID, --last_update_login,
2384: sysdate, --creation_date,
2385: FND_GLOBAL.USER_ID, --created_by,
2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2388: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2389: sysdate --program_update_date

Line 2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2382: FND_GLOBAL.USER_ID, --last_updated_by,
2383: FND_GLOBAL.USER_ID, --last_update_login,
2384: sysdate, --creation_date,
2385: FND_GLOBAL.USER_ID, --created_by,
2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2388: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2389: sysdate --program_update_date
2390: from cst_write_offs cwo

Line 2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2383: FND_GLOBAL.USER_ID, --last_update_login,
2384: sysdate, --creation_date,
2385: FND_GLOBAL.USER_ID, --created_by,
2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2388: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2389: sysdate --program_update_date
2390: from cst_write_offs cwo
2391: where cwo.write_off_id = c_wo_rec.l_wo_id

Line 2388: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2384: sysdate, --creation_date,
2385: FND_GLOBAL.USER_ID, --created_by,
2386: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2387: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2388: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2389: sysdate --program_update_date
2390: from cst_write_offs cwo
2391: where cwo.write_off_id = c_wo_rec.l_wo_id
2392: and cwo.po_distribution_id = c_wo_rec.po_distribution_id