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 936: FND_GLOBAL.USER_ID, --last_updated_by,

932: c_wo_rec.vendor_id,
933: l_le_id,
934: p_ou_id,
935: sysdate, --last_update_date,
936: FND_GLOBAL.USER_ID, --last_updated_by,
937: FND_GLOBAL.USER_ID, --last_update_login,
938: sysdate, --creation_date,
939: FND_GLOBAL.USER_ID, --created_by,
940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 937: FND_GLOBAL.USER_ID, --last_update_login,

933: l_le_id,
934: p_ou_id,
935: sysdate, --last_update_date,
936: FND_GLOBAL.USER_ID, --last_updated_by,
937: FND_GLOBAL.USER_ID, --last_update_login,
938: sysdate, --creation_date,
939: FND_GLOBAL.USER_ID, --created_by,
940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 939: FND_GLOBAL.USER_ID, --created_by,

935: sysdate, --last_update_date,
936: FND_GLOBAL.USER_ID, --last_updated_by,
937: FND_GLOBAL.USER_ID, --last_update_login,
938: sysdate, --creation_date,
939: FND_GLOBAL.USER_ID, --created_by,
940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
942: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
943: sysdate -- program_update_date

Line 940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

936: FND_GLOBAL.USER_ID, --last_updated_by,
937: FND_GLOBAL.USER_ID, --last_update_login,
938: sysdate, --creation_date,
939: FND_GLOBAL.USER_ID, --created_by,
940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
942: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
943: sysdate -- program_update_date
944: )

Line 941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

937: FND_GLOBAL.USER_ID, --last_update_login,
938: sysdate, --creation_date,
939: FND_GLOBAL.USER_ID, --created_by,
940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
942: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
943: sysdate -- program_update_date
944: )
945: into cst_write_off_details

Line 942: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

938: sysdate, --creation_date,
939: FND_GLOBAL.USER_ID, --created_by,
940: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
941: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
942: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
943: sysdate -- program_update_date
944: )
945: into cst_write_off_details
946: (

Line 990: FND_GLOBAL.USER_ID, --last_updated_by,

986: c_wo_rec.inventory_transaction_id,
987: c_wo_rec.inventory_organization_id,
988: p_ou_id,
989: sysdate, --last_update_date,
990: FND_GLOBAL.USER_ID, --last_updated_by,
991: FND_GLOBAL.USER_ID, --last_update_login,
992: sysdate, --creation_date,
993: FND_GLOBAL.USER_ID, --created_by,
994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 991: FND_GLOBAL.USER_ID, --last_update_login,

987: c_wo_rec.inventory_organization_id,
988: p_ou_id,
989: sysdate, --last_update_date,
990: FND_GLOBAL.USER_ID, --last_updated_by,
991: FND_GLOBAL.USER_ID, --last_update_login,
992: sysdate, --creation_date,
993: FND_GLOBAL.USER_ID, --created_by,
994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
995: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 993: FND_GLOBAL.USER_ID, --created_by,

989: sysdate, --last_update_date,
990: FND_GLOBAL.USER_ID, --last_updated_by,
991: FND_GLOBAL.USER_ID, --last_update_login,
992: sysdate, --creation_date,
993: FND_GLOBAL.USER_ID, --created_by,
994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
995: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
996: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
997: sysdate, --program_update_date,

Line 994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

990: FND_GLOBAL.USER_ID, --last_updated_by,
991: FND_GLOBAL.USER_ID, --last_update_login,
992: sysdate, --creation_date,
993: FND_GLOBAL.USER_ID, --created_by,
994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
995: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
996: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
997: sysdate, --program_update_date,
998: c_wo_rec.ae_header_id,

Line 995: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

991: FND_GLOBAL.USER_ID, --last_update_login,
992: sysdate, --creation_date,
993: FND_GLOBAL.USER_ID, --created_by,
994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
995: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
996: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
997: sysdate, --program_update_date,
998: c_wo_rec.ae_header_id,
999: c_wo_rec.ae_line_num

Line 996: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

992: sysdate, --creation_date,
993: FND_GLOBAL.USER_ID, --created_by,
994: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
995: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
996: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
997: sysdate, --program_update_date,
998: c_wo_rec.ae_header_id,
999: c_wo_rec.ae_line_num
1000: )

Line 1286: FND_GLOBAL.USER_ID, --last_updated_by,

1282: capr.write_off_id,
1283: capr.inventory_organization_id,
1284: capr.operating_unit_id,
1285: sysdate, --last_update_date,
1286: FND_GLOBAL.USER_ID, --last_updated_by,
1287: FND_GLOBAL.USER_ID, --last_update_login,
1288: sysdate, --creation_date,
1289: FND_GLOBAL.USER_ID, --created_by,
1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1287: FND_GLOBAL.USER_ID, --last_update_login,

1283: capr.inventory_organization_id,
1284: capr.operating_unit_id,
1285: sysdate, --last_update_date,
1286: FND_GLOBAL.USER_ID, --last_updated_by,
1287: FND_GLOBAL.USER_ID, --last_update_login,
1288: sysdate, --creation_date,
1289: FND_GLOBAL.USER_ID, --created_by,
1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1291: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1289: FND_GLOBAL.USER_ID, --created_by,

1285: sysdate, --last_update_date,
1286: FND_GLOBAL.USER_ID, --last_updated_by,
1287: FND_GLOBAL.USER_ID, --last_update_login,
1288: sysdate, --creation_date,
1289: FND_GLOBAL.USER_ID, --created_by,
1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1291: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1292: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1293: sysdate, --program_update_date,

Line 1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1286: FND_GLOBAL.USER_ID, --last_updated_by,
1287: FND_GLOBAL.USER_ID, --last_update_login,
1288: sysdate, --creation_date,
1289: FND_GLOBAL.USER_ID, --created_by,
1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1291: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1292: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1293: sysdate, --program_update_date,
1294: capr.ae_header_id,

Line 1291: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1287: FND_GLOBAL.USER_ID, --last_update_login,
1288: sysdate, --creation_date,
1289: FND_GLOBAL.USER_ID, --created_by,
1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1291: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1292: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1293: sysdate, --program_update_date,
1294: capr.ae_header_id,
1295: capr.ae_line_num

Line 1292: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1288: sysdate, --creation_date,
1289: FND_GLOBAL.USER_ID, --created_by,
1290: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1291: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1292: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1293: sysdate, --program_update_date,
1294: capr.ae_header_id,
1295: capr.ae_line_num
1296: from cst_ap_po_reconciliation capr

Line 1458: FND_GLOBAL.USER_ID, --last_updated_by,

1454: c_wo_rec.inventory_item_id,
1455: c_wo_rec.vendor_id,
1456: p_ou_id,
1457: sysdate, --last_update_date,
1458: FND_GLOBAL.USER_ID, --last_updated_by,
1459: FND_GLOBAL.USER_ID, --last_update_login,
1460: sysdate, --creation_date,
1461: FND_GLOBAL.USER_ID, --created_by,
1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1459: FND_GLOBAL.USER_ID, --last_update_login,

1455: c_wo_rec.vendor_id,
1456: p_ou_id,
1457: sysdate, --last_update_date,
1458: FND_GLOBAL.USER_ID, --last_updated_by,
1459: FND_GLOBAL.USER_ID, --last_update_login,
1460: sysdate, --creation_date,
1461: FND_GLOBAL.USER_ID, --created_by,
1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1463: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1461: FND_GLOBAL.USER_ID, --created_by,

1457: sysdate, --last_update_date,
1458: FND_GLOBAL.USER_ID, --last_updated_by,
1459: FND_GLOBAL.USER_ID, --last_update_login,
1460: sysdate, --creation_date,
1461: FND_GLOBAL.USER_ID, --created_by,
1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1463: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1464: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1465: sysdate --program_update_date

Line 1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1458: FND_GLOBAL.USER_ID, --last_updated_by,
1459: FND_GLOBAL.USER_ID, --last_update_login,
1460: sysdate, --creation_date,
1461: FND_GLOBAL.USER_ID, --created_by,
1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1463: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1464: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1465: sysdate --program_update_date
1466: );

Line 1463: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1459: FND_GLOBAL.USER_ID, --last_update_login,
1460: sysdate, --creation_date,
1461: FND_GLOBAL.USER_ID, --created_by,
1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1463: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1464: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1465: sysdate --program_update_date
1466: );
1467: --}

Line 1464: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1460: sysdate, --creation_date,
1461: FND_GLOBAL.USER_ID, --created_by,
1462: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1463: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1464: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1465: sysdate --program_update_date
1466: );
1467: --}
1468: end loop; /* for c_wo_rec in c_wo(p_ou_id) */

Line 1915: FND_GLOBAL.USER_ID, --last_updated_by,

1911: c_wo_rec.vendor_id,
1912: c_wo_rec.legal_entity_id,
1913: c_wo_rec.operating_unit_id,
1914: sysdate, --last_update_date,
1915: FND_GLOBAL.USER_ID, --last_updated_by,
1916: FND_GLOBAL.USER_ID, --last_update_login,
1917: sysdate, --creation_date,
1918: FND_GLOBAL.USER_ID, --created_by,
1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1916: FND_GLOBAL.USER_ID, --last_update_login,

1912: c_wo_rec.legal_entity_id,
1913: c_wo_rec.operating_unit_id,
1914: sysdate, --last_update_date,
1915: FND_GLOBAL.USER_ID, --last_updated_by,
1916: FND_GLOBAL.USER_ID, --last_update_login,
1917: sysdate, --creation_date,
1918: FND_GLOBAL.USER_ID, --created_by,
1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1920: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1918: FND_GLOBAL.USER_ID, --created_by,

1914: sysdate, --last_update_date,
1915: FND_GLOBAL.USER_ID, --last_updated_by,
1916: FND_GLOBAL.USER_ID, --last_update_login,
1917: sysdate, --creation_date,
1918: FND_GLOBAL.USER_ID, --created_by,
1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1920: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1921: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1922: sysdate --program_update_date

Line 1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1915: FND_GLOBAL.USER_ID, --last_updated_by,
1916: FND_GLOBAL.USER_ID, --last_update_login,
1917: sysdate, --creation_date,
1918: FND_GLOBAL.USER_ID, --created_by,
1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1920: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1921: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1922: sysdate --program_update_date
1923: );

Line 1920: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1916: FND_GLOBAL.USER_ID, --last_update_login,
1917: sysdate, --creation_date,
1918: FND_GLOBAL.USER_ID, --created_by,
1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1920: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1921: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1922: sysdate --program_update_date
1923: );
1924:

Line 1921: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1917: sysdate, --creation_date,
1918: FND_GLOBAL.USER_ID, --created_by,
1919: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1920: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1921: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1922: sysdate --program_update_date
1923: );
1924:
1925: l_stmt_num := 25;

Line 1978: FND_GLOBAL.USER_ID, --last_updated_by,

1974: cwod.write_off_transaction_id,
1975: cwod.inventory_organization_id,
1976: cwod.operating_unit_id,
1977: sysdate, --last_update_date,
1978: FND_GLOBAL.USER_ID, --last_updated_by,
1979: FND_GLOBAL.USER_ID, --last_update_login,
1980: sysdate, --creation_date,
1981: FND_GLOBAL.USER_ID, --created_by,
1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 1979: FND_GLOBAL.USER_ID, --last_update_login,

1975: cwod.inventory_organization_id,
1976: cwod.operating_unit_id,
1977: sysdate, --last_update_date,
1978: FND_GLOBAL.USER_ID, --last_updated_by,
1979: FND_GLOBAL.USER_ID, --last_update_login,
1980: sysdate, --creation_date,
1981: FND_GLOBAL.USER_ID, --created_by,
1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1983: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 1981: FND_GLOBAL.USER_ID, --created_by,

1977: sysdate, --last_update_date,
1978: FND_GLOBAL.USER_ID, --last_updated_by,
1979: FND_GLOBAL.USER_ID, --last_update_login,
1980: sysdate, --creation_date,
1981: FND_GLOBAL.USER_ID, --created_by,
1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1983: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1984: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1985: sysdate, --program_update_date,

Line 1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

1978: FND_GLOBAL.USER_ID, --last_updated_by,
1979: FND_GLOBAL.USER_ID, --last_update_login,
1980: sysdate, --creation_date,
1981: FND_GLOBAL.USER_ID, --created_by,
1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1983: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1984: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1985: sysdate, --program_update_date,
1986: cwod.ae_header_id,

Line 1983: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

1979: FND_GLOBAL.USER_ID, --last_update_login,
1980: sysdate, --creation_date,
1981: FND_GLOBAL.USER_ID, --created_by,
1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1983: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1984: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1985: sysdate, --program_update_date,
1986: cwod.ae_header_id,
1987: cwod.ae_line_num

Line 1984: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

1980: sysdate, --creation_date,
1981: FND_GLOBAL.USER_ID, --created_by,
1982: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
1983: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
1984: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
1985: sysdate, --program_update_date,
1986: cwod.ae_header_id,
1987: cwod.ae_line_num
1988: from cst_write_off_details cwod

Line 2051: FND_GLOBAL.USER_ID, --last_updated_by,

2047: cwo.vendor_id,
2048: cwod.inventory_organization_id,
2049: cwod.operating_unit_id,
2050: sysdate, --last_update_date,
2051: FND_GLOBAL.USER_ID, --last_updated_by,
2052: FND_GLOBAL.USER_ID, --last_update_login,
2053: sysdate, --creation_date,
2054: FND_GLOBAL.USER_ID, --created_by,
2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2052: FND_GLOBAL.USER_ID, --last_update_login,

2048: cwod.inventory_organization_id,
2049: cwod.operating_unit_id,
2050: sysdate, --last_update_date,
2051: FND_GLOBAL.USER_ID, --last_updated_by,
2052: FND_GLOBAL.USER_ID, --last_update_login,
2053: sysdate, --creation_date,
2054: FND_GLOBAL.USER_ID, --created_by,
2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2056: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2054: FND_GLOBAL.USER_ID, --created_by,

2050: sysdate, --last_update_date,
2051: FND_GLOBAL.USER_ID, --last_updated_by,
2052: FND_GLOBAL.USER_ID, --last_update_login,
2053: sysdate, --creation_date,
2054: FND_GLOBAL.USER_ID, --created_by,
2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2056: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2057: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2058: sysdate, --program_update_date,

Line 2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2051: FND_GLOBAL.USER_ID, --last_updated_by,
2052: FND_GLOBAL.USER_ID, --last_update_login,
2053: sysdate, --creation_date,
2054: FND_GLOBAL.USER_ID, --created_by,
2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2056: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2057: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2058: sysdate, --program_update_date,
2059: cwod.ae_header_id,

Line 2056: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2052: FND_GLOBAL.USER_ID, --last_update_login,
2053: sysdate, --creation_date,
2054: FND_GLOBAL.USER_ID, --created_by,
2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2056: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2057: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2058: sysdate, --program_update_date,
2059: cwod.ae_header_id,
2060: cwod.ae_line_num

Line 2057: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2053: sysdate, --creation_date,
2054: FND_GLOBAL.USER_ID, --created_by,
2055: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2056: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2057: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2058: sysdate, --program_update_date,
2059: cwod.ae_header_id,
2060: cwod.ae_line_num
2061: from cst_write_off_details cwod,

Line 2140: FND_GLOBAL.USER_ID, --last_updated_by,

2136: cwod.write_off_transaction_id,
2137: cwod.inventory_organization_id,
2138: cwod.operating_unit_id,
2139: sysdate, --last_update_date,
2140: FND_GLOBAL.USER_ID, --last_updated_by,
2141: FND_GLOBAL.USER_ID, --last_update_login,
2142: sysdate, --creation_date,
2143: FND_GLOBAL.USER_ID, --created_by,
2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2141: FND_GLOBAL.USER_ID, --last_update_login,

2137: cwod.inventory_organization_id,
2138: cwod.operating_unit_id,
2139: sysdate, --last_update_date,
2140: FND_GLOBAL.USER_ID, --last_updated_by,
2141: FND_GLOBAL.USER_ID, --last_update_login,
2142: sysdate, --creation_date,
2143: FND_GLOBAL.USER_ID, --created_by,
2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2145: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2143: FND_GLOBAL.USER_ID, --created_by,

2139: sysdate, --last_update_date,
2140: FND_GLOBAL.USER_ID, --last_updated_by,
2141: FND_GLOBAL.USER_ID, --last_update_login,
2142: sysdate, --creation_date,
2143: FND_GLOBAL.USER_ID, --created_by,
2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2145: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2146: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2147: sysdate, --program_update_date,

Line 2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2140: FND_GLOBAL.USER_ID, --last_updated_by,
2141: FND_GLOBAL.USER_ID, --last_update_login,
2142: sysdate, --creation_date,
2143: FND_GLOBAL.USER_ID, --created_by,
2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2145: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2146: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2147: sysdate, --program_update_date,
2148: cwod.ae_header_id,

Line 2145: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2141: FND_GLOBAL.USER_ID, --last_update_login,
2142: sysdate, --creation_date,
2143: FND_GLOBAL.USER_ID, --created_by,
2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2145: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2146: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2147: sysdate, --program_update_date,
2148: cwod.ae_header_id,
2149: cwod.ae_line_num

Line 2146: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2142: sysdate, --creation_date,
2143: FND_GLOBAL.USER_ID, --created_by,
2144: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2145: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2146: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2147: sysdate, --program_update_date,
2148: cwod.ae_header_id,
2149: cwod.ae_line_num
2150: from cst_write_offs cwo,

Line 2199: FND_GLOBAL.USER_ID, --last_updated_by,

2195: cwo.transaction_type_code,
2196: cwo.write_off_id,
2197: cwo.operating_unit_id,
2198: sysdate, --last_update_date,
2199: FND_GLOBAL.USER_ID, --last_updated_by,
2200: FND_GLOBAL.USER_ID, --last_update_login,
2201: sysdate, --creation_date,
2202: FND_GLOBAL.USER_ID, --created_by,
2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2200: FND_GLOBAL.USER_ID, --last_update_login,

2196: cwo.write_off_id,
2197: cwo.operating_unit_id,
2198: sysdate, --last_update_date,
2199: FND_GLOBAL.USER_ID, --last_updated_by,
2200: FND_GLOBAL.USER_ID, --last_update_login,
2201: sysdate, --creation_date,
2202: FND_GLOBAL.USER_ID, --created_by,
2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2202: FND_GLOBAL.USER_ID, --created_by,

2198: sysdate, --last_update_date,
2199: FND_GLOBAL.USER_ID, --last_updated_by,
2200: FND_GLOBAL.USER_ID, --last_update_login,
2201: sysdate, --creation_date,
2202: FND_GLOBAL.USER_ID, --created_by,
2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2205: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2206: sysdate --program_update_date

Line 2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2199: FND_GLOBAL.USER_ID, --last_updated_by,
2200: FND_GLOBAL.USER_ID, --last_update_login,
2201: sysdate, --creation_date,
2202: FND_GLOBAL.USER_ID, --created_by,
2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2205: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2206: sysdate --program_update_date
2207: from cst_write_offs cwo

Line 2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2200: FND_GLOBAL.USER_ID, --last_update_login,
2201: sysdate, --creation_date,
2202: FND_GLOBAL.USER_ID, --created_by,
2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2205: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2206: sysdate --program_update_date
2207: from cst_write_offs cwo
2208: where cwo.write_off_id in (c_wo_rec.l_wo_id, c_wo_rec.l_rev_id)

Line 2205: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2201: sysdate, --creation_date,
2202: FND_GLOBAL.USER_ID, --created_by,
2203: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2204: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2205: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2206: sysdate --program_update_date
2207: from cst_write_offs cwo
2208: where cwo.write_off_id in (c_wo_rec.l_wo_id, c_wo_rec.l_rev_id)
2209: and cwo.po_distribution_id = c_wo_rec.po_distribution_id

Line 2257: FND_GLOBAL.USER_ID, --last_updated_by,

2253: cwo.vendor_id,
2254: cwo.destination_type_code,
2255: cwo.operating_unit_id,
2256: sysdate, --last_update_date,
2257: FND_GLOBAL.USER_ID, --last_updated_by,
2258: FND_GLOBAL.USER_ID, --last_update_login,
2259: sysdate, --creation_date,
2260: FND_GLOBAL.USER_ID, --created_by,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2258: FND_GLOBAL.USER_ID, --last_update_login,

2254: cwo.destination_type_code,
2255: cwo.operating_unit_id,
2256: sysdate, --last_update_date,
2257: FND_GLOBAL.USER_ID, --last_updated_by,
2258: FND_GLOBAL.USER_ID, --last_update_login,
2259: sysdate, --creation_date,
2260: FND_GLOBAL.USER_ID, --created_by,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2260: FND_GLOBAL.USER_ID, --created_by,

2256: sysdate, --last_update_date,
2257: FND_GLOBAL.USER_ID, --last_updated_by,
2258: FND_GLOBAL.USER_ID, --last_update_login,
2259: sysdate, --creation_date,
2260: FND_GLOBAL.USER_ID, --created_by,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2263: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2264: sysdate --program_update_date

Line 2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2257: FND_GLOBAL.USER_ID, --last_updated_by,
2258: FND_GLOBAL.USER_ID, --last_update_login,
2259: sysdate, --creation_date,
2260: FND_GLOBAL.USER_ID, --created_by,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2263: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2264: sysdate --program_update_date
2265: from cst_ap_po_reconciliation capr,

Line 2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2258: FND_GLOBAL.USER_ID, --last_update_login,
2259: sysdate, --creation_date,
2260: FND_GLOBAL.USER_ID, --created_by,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2263: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2264: sysdate --program_update_date
2265: from cst_ap_po_reconciliation capr,
2266: cst_write_offs cwo

Line 2263: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2259: sysdate, --creation_date,
2260: FND_GLOBAL.USER_ID, --created_by,
2261: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2262: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2263: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2264: sysdate --program_update_date
2265: from cst_ap_po_reconciliation capr,
2266: cst_write_offs cwo
2267: where cwo.write_off_id = c_wo_rec.l_wo_id

Line 2372: FND_GLOBAL.USER_ID, --last_updated_by,

2368: cwo.transaction_type_code,
2369: cwo.write_off_id,
2370: cwo.operating_unit_id,
2371: sysdate, --last_update_date,
2372: FND_GLOBAL.USER_ID, --last_updated_by,
2373: FND_GLOBAL.USER_ID, --last_update_login,
2374: sysdate, --creation_date,
2375: FND_GLOBAL.USER_ID, --created_by,
2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

Line 2373: FND_GLOBAL.USER_ID, --last_update_login,

2369: cwo.write_off_id,
2370: cwo.operating_unit_id,
2371: sysdate, --last_update_date,
2372: FND_GLOBAL.USER_ID, --last_updated_by,
2373: FND_GLOBAL.USER_ID, --last_update_login,
2374: sysdate, --creation_date,
2375: FND_GLOBAL.USER_ID, --created_by,
2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

Line 2375: FND_GLOBAL.USER_ID, --created_by,

2371: sysdate, --last_update_date,
2372: FND_GLOBAL.USER_ID, --last_updated_by,
2373: FND_GLOBAL.USER_ID, --last_update_login,
2374: sysdate, --creation_date,
2375: FND_GLOBAL.USER_ID, --created_by,
2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2378: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2379: sysdate --program_update_date

Line 2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,

2372: FND_GLOBAL.USER_ID, --last_updated_by,
2373: FND_GLOBAL.USER_ID, --last_update_login,
2374: sysdate, --creation_date,
2375: FND_GLOBAL.USER_ID, --created_by,
2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2378: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2379: sysdate --program_update_date
2380: from cst_write_offs cwo

Line 2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,

2373: FND_GLOBAL.USER_ID, --last_update_login,
2374: sysdate, --creation_date,
2375: FND_GLOBAL.USER_ID, --created_by,
2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2378: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2379: sysdate --program_update_date
2380: from cst_write_offs cwo
2381: where cwo.write_off_id = c_wo_rec.l_wo_id

Line 2378: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,

2374: sysdate, --creation_date,
2375: FND_GLOBAL.USER_ID, --created_by,
2376: FND_GLOBAL.CONC_REQUEST_ID, --request_id,
2377: FND_GLOBAL.PROG_APPL_ID, --program_application_id,
2378: FND_GLOBAL.CONC_PROGRAM_ID, --program_id,
2379: sysdate --program_update_date
2380: from cst_write_offs cwo
2381: where cwo.write_off_id = c_wo_rec.l_wo_id
2382: and cwo.po_distribution_id = c_wo_rec.po_distribution_id