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.PA_CHECK_COMMITMENTS dependencies on PA_COMMITMENT_TXNS

Line 40: Checks Client Extension for commitments against PA_Commitment_Txns

36: FETCH is_cash_basis_enabled_cur into is_cash_basis_enabled_flag;
37: CLOSE is_cash_basis_enabled_cur;
38:
39: /* First Block: NEW COMMITMENTS VIA CLIENT EXTENSION
40: Checks Client Extension for commitments against PA_Commitment_Txns
41: */
42:
43:
44:

Line 88: FROM PA_COMMITMENT_TXNS CMT

84: AND T.project_id = p_ProjectID
85: AND enc1.enc_distributed_flag = 'Y'
86: MINUS
87: SELECT CMT.CMT_Header_ID
88: FROM PA_COMMITMENT_TXNS CMT
89: WHERE CMT.Line_Type = 'N'
90: AND CMT.Project_ID = p_ProjectID
91: AND CMT.Transaction_Source = 'OUTSIDE_SYSTEM');
92: -- Bug 3504811 : End

Line 111: Checks the PO Req Distributions' tables against PA_Commitment_Txns

107: end if;
108: /* Code addition for bug 3258046 ends */
109:
110: /* Second Block: NEW REQUISITIONS
111: Checks the PO Req Distributions' tables against PA_Commitment_Txns
112: for new Purchase Requisitions
113: */
114:
115: /* Bug 1517186 made chagnes for performance tuning.

Line 165: FROM PA_COMMITMENT_TXNS CMT

161: AND RD.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
162: AND RD.Project_ID = p_ProjectID
163: AND NOT EXISTS (
164: SELECT '2'
165: FROM PA_COMMITMENT_TXNS CMT
166: WHERE CMT.Line_Type = 'R'
167: AND CMT.Project_ID = p_ProjectID
168: AND CMT.Burden_Sum_Dest_Run_ID is NULL
169: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 184: Checks the AP Inv Distributions' tables against PA_Commitment_Txns

180: End; -- Second Block, for new PO Reqs
181:
182:
183: /* Third Block: NEW AP INVOICES
184: Checks the AP Inv Distributions' tables against PA_Commitment_Txns
185: for new Invoices
186: */
187:
188: v_tmp := 'N';

Line 205: FROM PA_COMMITMENT_TXNS CMT

201: WHERE
202: apd.PROJECT_ID = p_ProjectID
203: AND NOT EXISTS (
204: SELECT '2'
205: FROM PA_COMMITMENT_TXNS CMT
206: WHERE CMT.Line_Type = 'I'
207: AND CMT.Project_ID = p_ProjectID
208: AND CMT.Burden_Sum_Dest_Run_ID is NULL
209: AND CMT.Transaction_Source = 'ORACLE_PAYABLES'

Line 236: FROM PA_COMMITMENT_TXNS CMT

232: AND nvl(I.source, 'xxx') not in ('Oracle Project Accounting','PA_IC_INVOICES')
233: AND D.Project_ID = p_ProjectID
234: AND NOT EXISTS (
235: SELECT '2'
236: FROM PA_COMMITMENT_TXNS CMT
237: WHERE CMT.Line_Type = 'I'
238: AND CMT.Project_ID = p_ProjectID
239: AND CMT.Burden_Sum_Dest_Run_ID is NULL
240: AND CMT.Transaction_Source = 'ORACLE_PAYABLES'

Line 254: Checks the PO distributions' tables against PA_Commitment_Txns

250: v_tmp := 'N';
251: End; -- Third Block, for new AP Invoices
252:
253: /* Fourth Block: NEW POs
254: Checks the PO distributions' tables against PA_Commitment_Txns
255: for new POs
256: */
257:
258: v_tmp := 'N';

Line 306: FROM PA_COMMITMENT_TXNS CMT

302: AND POL.PO_Line_ID = POD.PO_Line_ID
303: AND POD.Project_ID = p_ProjectID
304: AND NOT EXISTS (
305: SELECT '2'
306: FROM PA_COMMITMENT_TXNS CMT
307: WHERE CMT.Line_Type = 'P'
308: AND CMT.Project_ID = p_ProjectID
309: AND CMT.Burden_Sum_Dest_Run_ID is NULL
310: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 325: Checks the PO distributions' tables against PA_Commitment_Txns

321: End; -- Fourth Block, for new POs
322:
323:
324: /* Fifth Block: UPDATED POs
325: Checks the PO distributions' tables against PA_Commitment_Txns
326: for updated POs
327: Note: For POs, all amounts are captured in Oracle Purchasing as denom amounts.
328: */
329:

Line 340: FROM PA_COMMITMENT_TXNS CMT

336: FROM DUAL
337: WHERE EXISTS
338: (
339: SELECT '1'
340: FROM PA_COMMITMENT_TXNS CMT
341: WHERE CMT.Project_ID = p_ProjectID
342: AND CMT.Burden_Sum_Dest_Run_ID is NULL
343: AND CMT.Line_Type||'' = 'P'
344: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 471: Checks the AP Inv Distributions' tables against PA_Commitment_Txns

467: End; -- Fifth Block, for updated POs
468:
469:
470: /* Sixth Block: UPDATED INVOICES
471: Checks the AP Inv Distributions' tables against PA_Commitment_Txns
472: for updated Invoices
473: Note: For AP Invoices, all amounts are captured in Oracle Payables as denom amounts.
474: */
475:

Line 486: FROM PA_COMMITMENT_TXNS CMT

482: FROM DUAL
483: WHERE EXISTS
484: (
485: SELECT '1'
486: FROM PA_COMMITMENT_TXNS CMT
487: WHERE CMT.Project_ID = p_ProjectID
488: AND CMT.Burden_Sum_Dest_Run_ID is NULL
489: AND CMT.Line_Type||'' = 'I'
490: AND CMT.Transaction_Source = 'ORACLE_PAYABLES'

Line 559: Checks the PO Req Distributions' tables against PA_Commitment_Txns

555: End; -- Sixth Block, for updated AP Invoices
556:
557:
558: /* Seventh Block: UPADTED REQUISTIONS
559: Checks the PO Req Distributions' tables against PA_Commitment_Txns
560: for updated Purchase Requisitions
561:
562: Note: For Requisitions, unit price is always captured in accounting currency! Therefore,
563: the raw cost and burdened cost comparative joins in this block use ACCT columns.

Line 578: FROM PA_COMMITMENT_TXNS CMT

574: FROM DUAL
575: WHERE EXISTS
576: (
577: SELECT '1'
578: FROM PA_COMMITMENT_TXNS CMT
579: WHERE CMT.Project_ID = p_ProjectID
580: AND CMT.Burden_Sum_Dest_Run_ID is NULL
581: AND CMT.Line_Type||'' = 'R'
582: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 657: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns

653: End; -- Seventh Block, for updated PO Reqs
654:
655:
656: /* Eighth Block: UPDATED MFG COMMITMENTS
657: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns
658: for updated commitments
659:
660: Note: For MFG commitments, the view returns both acct and denom amounts for most amount
661: columns, So, where possible, joins are performed for denom amounts.

Line 674: FROM PA_COMMITMENT_TXNS CMT

670: FROM DUAL
671: WHERE EXISTS
672: (
673: SELECT '1'
674: FROM PA_COMMITMENT_TXNS CMT
675: WHERE CMT.Project_ID = p_ProjectID
676: AND CMT.Burden_Sum_Dest_Run_ID is NULL
677: AND CMT.Transaction_Source = 'ORACLE_MANUFACTURING'
678: AND NOT EXISTS

Line 739: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns

735: End; -- Eighth Block, for updated commitments from CST_PROJMFG_CMT_VIEW
736:
737:
738: /* Ninth Block: NEW MFG COMMITMENTS
739: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns
740: for new commitments
741: */
742:
743: v_tmp := 'N';

Line 758: FROM PA_COMMITMENT_TXNS CMT

754: WHERE
755: CST.PROJECT_ID = p_ProjectID
756: AND NOT EXISTS (
757: SELECT '2'
758: FROM PA_COMMITMENT_TXNS CMT
759: WHERE CMT.Transaction_Source = 'ORACLE_MANUFACTURING'
760: AND CMT.Project_ID = p_ProjectID
761: AND CMT.Burden_Sum_Dest_Run_ID is NULL
762: AND CMT.CMT_Header_ID = CST.CMT_Header_ID

Line 777: Checks the PJM Req Commitments View against PA_Commitment_Txns

773:
774: /* Added the following four blocks for the bug #3631172. */
775:
776: /* Tenth Block: NEW Shop Floor/Inventory REQUISITIONS
777: Checks the PJM Req Commitments View against PA_Commitment_Txns
778: for new Shop Floor/Inventory Purchase Requisitions.
779: */
780:
781: v_tmp := 'N';

Line 796: FROM PA_COMMITMENT_TXNS CMT

792: WHERE
793: PJREQ.Project_ID = p_ProjectID
794: AND NOT EXISTS (
795: SELECT '2'
796: FROM PA_COMMITMENT_TXNS CMT
797: WHERE CMT.Line_Type = 'R'
798: AND CMT.Project_ID = p_ProjectID
799: AND CMT.Burden_Sum_Dest_Run_ID is NULL
800: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 865: FROM PA_COMMITMENT_TXNS CMT

861: AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
862: AND UOM.UNIT_OF_MEASURE = RL.UNIT_MEAS_LOOKUP_CODE)
863: WHERE NOT EXISTS (
864: SELECT '2'
865: FROM PA_COMMITMENT_TXNS CMT
866: WHERE CMT.Line_Type = 'R'
867: AND CMT.Project_ID = p_ProjectID
868: AND CMT.Burden_Sum_Dest_Run_ID is NULL
869: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 927: FROM PA_COMMITMENT_TXNS CMT

923: AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
924: AND UOM.UNIT_OF_MEASURE = RL.UNIT_MEAS_LOOKUP_CODE)
925: WHERE NOT EXISTS (
926: SELECT '2'
927: FROM PA_COMMITMENT_TXNS CMT
928: WHERE CMT.Line_Type = 'R'
929: AND CMT.Project_ID = p_ProjectID
930: AND CMT.Burden_Sum_Dest_Run_ID is NULL
931: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 945: Checks the PJM Req Commitments View against PA_Commitment_Txns

941: End;
942: End; -- Tenth Block, for new Shop Floor/Inventory Reqs
943:
944: /* Eleventh Block: UPDATED Shop Floor/Inventory REQUISTIONS
945: Checks the PJM Req Commitments View against PA_Commitment_Txns
946: for updated Shop Floor/Inventory Purchase Requisitions.
947:
948: */
949:

Line 960: FROM PA_COMMITMENT_TXNS CMT

956: FROM DUAL
957: WHERE EXISTS
958: (
959: SELECT '1'
960: FROM PA_COMMITMENT_TXNS CMT
961: WHERE CMT.Project_ID = p_ProjectID
962: AND CMT.Burden_Sum_Dest_Run_ID is NULL
963: AND CMT.Line_Type||'' = 'R'
964: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 1007: Checks the PJM PO Commitments View against PA_Commitment_Txns

1003: v_tmp := 'N';
1004: End; -- Eleventh Block, for updated Shop Floor/Inventory Reqs
1005:
1006: /* Twelvth Block: NEW Shop Floor/Inventory POs
1007: Checks the PJM PO Commitments View against PA_Commitment_Txns
1008: for new Shop Floor/Inventory Purchase Orders
1009: */
1010:
1011: v_tmp := 'N';

Line 1027: FROM PA_COMMITMENT_TXNS CMT

1023: WHERE
1024: PJPO.Project_ID = p_ProjectID
1025: AND NOT EXISTS (
1026: SELECT '2'
1027: FROM PA_COMMITMENT_TXNS CMT
1028: WHERE CMT.Line_Type = 'P'
1029: AND CMT.Project_ID = p_ProjectID
1030: AND CMT.Burden_Sum_Dest_Run_ID is NULL
1031: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 1095: FROM PA_COMMITMENT_TXNS CMT

1091: AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
1092: AND UOM.UNIT_OF_MEASURE = POL.UNIT_MEAS_LOOKUP_CODE)
1093: WHERE NOT EXISTS (
1094: SELECT '2'
1095: FROM PA_COMMITMENT_TXNS CMT
1096: WHERE CMT.Line_Type = 'P'
1097: AND CMT.Project_ID = p_ProjectID
1098: AND CMT.Burden_Sum_Dest_Run_ID is NULL
1099: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 1157: FROM PA_COMMITMENT_TXNS CMT

1153: AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID
1154: AND UOM.UNIT_OF_MEASURE = POL.UNIT_MEAS_LOOKUP_CODE)
1155: WHERE NOT EXISTS (
1156: SELECT '2'
1157: FROM PA_COMMITMENT_TXNS CMT
1158: WHERE CMT.Line_Type = 'P'
1159: AND CMT.Project_ID = p_ProjectID
1160: AND CMT.Burden_Sum_Dest_Run_ID is NULL
1161: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'

Line 1175: Checks the PJM PO Commitments View against PA_Commitment_Txns

1171: End;
1172: End; -- Twelvth Block, for new Shop Floor/Inventory POs
1173:
1174: /* Thirteenth Block: Updated Shop Floor/Inventory POs
1175: Checks the PJM PO Commitments View against PA_Commitment_Txns
1176: for new Shop Floor/Inventory Purchase Orders
1177: */
1178:
1179: v_tmp := 'N';

Line 1189: FROM PA_COMMITMENT_TXNS CMT

1185: FROM DUAL
1186: WHERE EXISTS
1187: (
1188: SELECT '1'
1189: FROM PA_COMMITMENT_TXNS CMT
1190: WHERE CMT.Project_ID = p_ProjectID
1191: AND CMT.Burden_Sum_Dest_Run_ID is NULL
1192: AND CMT.Line_Type||'' = 'P'
1193: AND CMT.Transaction_Source = 'ORACLE_PURCHASING'