-- Consulta registrada el 2026-04-08T03:53:28.087266 select * FROM ra_customer_trx_all where trx_number in ('M-21832451-51744', 'AJ-BI-312904', 'AJ-P2-316012', 'AJ-P2-316013', 'AJ-P2-316014', 'AJ-P2-316015', 'AJ-P2-316016', 'AJ-P2-316017', 'AJ-P2-316018', 'AJ-P2-316019', 'AJ-P2-316020', 'AJ-P2-316021', 'AJ-P2-316022', 'AJ-P2-316023', 'AJ-P2-316024', 'AJ-P2-316025', 'AJ-P2-316026', 'AJ-P2-316027', 'AJ-P2-316028', 'AJ-P2-316029', 'AJ-P2-316030', 'AJ-P2-316031', 'AJ-P2-316032', 'AJ-P2-316033', 'AJ-P2-316034', 'AJ-P2-316035', 'AJ-P2-316036', 'AJ-P2-316037', 'AJ-P2-316038', 'AJ-P2-316039', 'AJ-P2-316040', 'AJ-P2-316041', 'AJ-P2-316042', 'AJ-P2-316043', 'AJ-P2-316044', 'AJ-P2-316045', 'AJ-P2-316046', 'AJ-P2-316047', 'AJ-P2-316048', 'AJ-P2-316049', 'AJ-P2-316050', 'AJ-P2-316051', 'AJ-P2-316052', 'AJ-P2-316053', 'AJ-P2-316054', 'AJ-P2-316055', 'AJ-P2-316056', 'AJ-P2-316057', 'AJ-P2-316058', 'AJ-P2-316059', 'AJ-P2-316060', 'AJ-P2-316094', 'AJ-P2-316095', 'AJ-P2-316096', 'AJ-P2-316097', 'AJ-P2-316098', 'AJ-P2-316099', 'AJ-P2-316100', 'AJ-P2-316101', 'AJ-P2-316102', 'AJ-P2-316103', 'AJ-P2-316104', 'AJ-P2-316105', 'AJ-P2-316106', 'AJ-P2-316107', 'AJ-P2-316108', 'AJ-P2-316109', 'AJ-P2-316110', 'AJ-P2-316111', 'AJ-P2-316112', 'AJ-P2-316113', 'AJ-P2-316114', 'AJ-P2-316115', 'AJ-P2-316116', 'AJ-P2-316117', 'AJ-P2-316118', 'AJ-P2-316119', 'AJ-P2-316120', 'AJ-P2-316121', 'AJ-P2-316122', 'AJ-P2-316123', 'AJ-P2-316124', 'AJ-P2-316125', 'AJ-P2-316126', 'MA-347701-00', 'MA-347697-00', 'MA-347698-00', 'MA-347811-00', 'INT-336564-01', 'AJ-29-322728', 'AR-337348-02', 'AR-337570-02', 'AR-338334-02', 'AR-328084-09', 'AR-338418-02', 'AR-340780-02', 'AR-341871-02', 'AR-320044-11', 'AR-336195-02', 'AR-336351-02', 'AR-343048-02', 'AR-345633-02', 'AR-332755-02', 'AR-336494-02', 'AR-333852-02', 'AR-335130-02', 'AR-345870-02', 'AR-345918-02', 'AR-343754-02', 'AR-335756-02', 'AR-344821-02', 'AR-345200-02', 'AR-344249-02', 'AR-335847-02', 'AR-335715-02', 'AR-334096-02', 'AR-335657-02', 'AR-340944-02', 'AR-341750-02', 'AR-336651-02', 'AR-336169-02', 'AR-342906-02', 'AR-330115-02', 'AR-341981-02', 'AR-337751-02', 'AR-333614-02', 'AR-335477-02', 'AR-345171-02', 'AR-335136-02', 'AR-332436-02', 'AR-338298-02', 'AR-341271-02', 'AR-335775-02', 'AR-333702-02', 'AR-335718-02', 'AR-338439-02', 'AR-342376-02', 'AR-344244-02', 'AR-336520-02', 'AR-344707-02', 'AR-340299-02', 'AR-335804-02', 'AR-338029-02', 'AR-336140-02', 'AR-343589-02', 'AR-338576-02', 'AR-334324-02', 'AR-335416-02', 'AR-334632-02', 'AR-344089-02', 'AR-345953-02', 'AR-331701-02', 'AR-338930-02', 'AR-342984-02', 'AR-333105-02', 'AR-331175-05', 'AR-342877-02', 'AR-341695-02', 'AR-333652-02', 'AR-342173-02', 'AR-336161-02', 'AR-334382-02', 'AR-343954-02', 'AR-335257-02', 'AR-338878-02', 'AR-336732-02', 'AR-346078-02', 'AR-342523-02', 'AR-340407-02', 'AR-345832-02', 'AR-338441-02', 'AR-333510-02', 'AR-328175-09', 'AR-331532-05', 'AR-335222-02', 'AR-342806-02', 'AR-336538-02', 'AR-342112-02', 'AR-345390-02', 'AR-341868-02', 'AR-304201-11', 'AR-330499-07') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-08T03:47:17.892677 select * FROM ra_customer_trx_all where trx_number in ('AR-325892-01') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-08T02:45:27.578380 select * FROM ra_customer_trx_all where trx_number in ('AR-307479-09', 'AR-313007-09', 'AR-311510-09', 'AR-315745-09', 'AR-312810-10', 'AR-311510-10', 'AR-312948-10', 'AR-315745-10', 'AR-315862-10', 'INT-312262-11', 'INT-307793-11', 'INT-312171-11', 'INT-311198-11', 'GCO-311198-11', 'INT-311901-11', 'INT-308025-08', 'INT-309098-11', 'INT-308546-11', 'INT-312382-11', 'INT-312109-11', 'INT-309208-11', 'INT-312084-11', 'INT-312535-11', 'INT-311450-11', 'INT-316288-11', 'INT-308989-11', 'GCO-308989-11', 'INT-308997-11', 'C-21205129-53893', 'C-21558579-56495', 'C-21084875-56496', 'C-21121832-56497', 'C-22254178-56498', 'C-21337153-56499', 'C-20283467-56513', 'C-26073034-52702', 'C-20470978-56529', 'C-18583407-56530', 'M-21139441-56531', 'C-22085908-56532', 'AR-333330-01', 'AR-333338-02', 'AR-333444-02', 'AR-333445-02', 'AR-333446-02', 'AR-333447-02', 'AR-333449-02', 'AR-333451-02', 'AR-333453-02', 'AR-333458-02', 'AR-333459-02', 'AR-333461-02', 'AR-333463-02', 'AR-333464-02', 'AR-333467-02', 'AR-333468-02', 'AR-333469-02', 'AR-333470-02', 'AR-333473-02', 'AR-333475-02', 'AR-333477-02', 'AR-333486-02', 'AR-333487-02', 'AR-333488-02', 'AR-333489-02', 'AR-333492-02', 'AR-333493-02', 'AR-333500-02', 'AR-333501-02', 'AR-333502-02', 'AR-333503-02', 'AR-333508-02', 'AR-333511-02', 'AR-333512-02', 'AR-333515-02', 'AR-333517-02', 'AR-333518-02', 'AR-333520-02', 'AR-333521-02', 'AR-333545-02', 'AR-333547-02', 'AR-333549-02', 'AR-333550-02', 'AR-333551-02', 'AR-333554-02', 'AR-333556-02', 'AR-333560-02', 'AR-333562-02', 'AR-333563-02', 'AR-333575-02', 'AR-333578-02', 'AR-333582-02', 'AR-333585-02', 'AR-333587-02', 'AR-333589-02', 'AR-333591-02', 'AR-333592-02', 'AR-333594-02', 'AR-333597-02', 'AR-333599-02', 'AR-333600-02', 'AR-333602-02', 'AR-333603-02', 'AR-333604-02', 'AR-333605-02', 'AR-333612-02', 'AR-333613-02', 'AR-333616-02', 'AR-333621-02', 'AR-333626-02', 'AR-333628-02', 'AR-333631-02', 'AR-333632-02', 'AR-333634-02', 'AR-333636-02', 'AR-333638-02', 'AR-333640-02', 'AR-333641-02', 'AR-333647-02', 'AR-333648-02', 'AR-333651-02', 'AR-333653-02', 'AR-333655-02', 'AR-333658-02', 'AR-333661-02', 'AR-333670-02', 'AR-333674-02', 'AR-333675-02', 'AR-333678-02', 'AR-333687-02', 'AR-333688-02', 'AR-333690-02', 'AR-333695-02', 'AR-333696-02', 'AR-333698-02', 'AR-333699-02', 'AR-333705-02', 'AR-333706-02', 'AR-333708-02', 'AR-333710-02', 'AR-333711-02', 'AR-333712-02', 'AR-333716-02', 'AR-333718-02', 'AR-333721-02', 'AR-333723-02', 'AR-333726-02', 'AR-333727-02', 'AR-333731-02', 'AR-333733-02', 'AR-333742-02', 'AR-333744-02', 'AR-333751-02', 'AR-333752-02', 'AR-333753-02', 'AR-333755-02', 'AR-333758-02', 'AR-333761-02', 'AR-333763-02') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T21:21:11.493792 SELECT * FROM ap_invoice_distributions_all fetch first 10 rows only -- Consulta registrada el 2026-04-07T21:00:42.582162 select * FROM ra_customer_trx_all where trx_number in ('MA-330091-00', 'MA-330112-00', 'MA-330249-00', 'MA-330299-00', 'MA-330367-00', 'MA-330517-00', 'MA-331496-00', 'MA-331682-00', 'MA-331687-00', 'MA-331847-00', 'MA-331956-00', 'MA-331982-00', 'MA-332077-00', 'MA-332429-00', 'MA-332825-00', 'MA-334068-00', 'MA-334227-00', 'MA-334234-00', 'MA-334273-00', 'MA-334434-00', 'MA-334935-00', 'MA-335044-00', 'MA-335240-00', 'MA-335244-00', 'MA-335439-00', 'MA-335458-00', 'MA-335914-00', 'MA-335950-00', 'MA-336069-00', 'MA-336098-00', 'MA-336154-00', 'MA-336186-00', 'MA-336380-00', 'MA-336392-00', 'MA-336431-00', 'MA-336452-00', 'MA-336467-00', 'MA-336545-00', 'MA-336558-00', 'MA-336586-00', 'MA-336587-00', 'MA-336614-00', 'MA-336751-00', 'MA-336765-00', 'MA-336789-00', 'MA-336793-00', 'MA-336795-00', 'MA-336883-00', 'MA-336885-00', 'MA-333902-00', 'AR-333902-01', 'AR-333902-02', 'AR-333902-03', 'AR-333902-04', 'AR-333902-05', 'AR-333902-06', 'AR-333902-07', 'AR-333902-08', 'AR-333902-09', 'AR-333902-10', 'MA-335365-00', 'AR-335365-01', 'AR-335365-02', 'AR-335365-03', 'AR-335365-04', 'AR-335365-05', 'AR-335365-06', 'AR-335365-07', 'AR-335365-08', 'AR-335365-09', 'AR-335365-10', 'MA-335840-00', 'AR-335840-01', 'AR-335840-02', 'AR-335840-03', 'AR-335840-04', 'AR-335840-05', 'AR-335840-06', 'AR-335840-07', 'AR-335840-08', 'AR-335840-09', 'AR-335840-10' ) FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T20:28:04.637163 select * FROM ra_customer_trx_all where trx_number in ('AR-169427-10', 'INT-312262-11', 'INT-307793-11', 'INT-312171-11', 'INT-311198-11', 'GCO-311198-11', 'INT-311901-11', 'INT-308025-08', 'INT-309098-11', 'INT-308546-11', 'INT-312382-11', 'INT-312109-11', 'INT-309208-11', 'INT-312084-11', 'INT-312535-11', 'INT-311450-11', 'AJ-1B-824909', 'AJ-1B-829420', 'INT-316288-11', 'AJ-P2-316012', 'AJ-P2-316013', 'AJ-P2-316014', 'AJ-P2-316015', 'AJ-P2-316016', 'AJ-P2-316017', 'AJ-P2-316018', 'AJ-P2-316019', 'AJ-P2-316020', 'AJ-P2-316021', 'AJ-P2-316022', 'AJ-P2-316023', 'AJ-P2-316024', 'AJ-P2-316025', 'AJ-P2-316026', 'AJ-P2-316027', 'AJ-P2-316028', 'AJ-P2-316029', 'AJ-P2-316030', 'AJ-P2-316031', 'AJ-P2-316032', 'AJ-P2-316033', 'AJ-P2-316034', 'AJ-P2-316035', 'AJ-P2-316036', 'AJ-P2-316037', 'AJ-P2-316038', 'AJ-P2-316039', 'AJ-P2-316040', 'AJ-P2-316041', 'AJ-P2-316042', 'AJ-P2-316043', 'AJ-P2-316044', 'AJ-P2-316045', 'AJ-P2-316046', 'AJ-P2-316047', 'AJ-P2-316048', 'AJ-P2-316049', 'AJ-P2-316050', 'AJ-P2-316051', 'AJ-P2-316052', 'AJ-P2-316053', 'AJ-P2-316054', 'AJ-P2-316055', 'AJ-P2-316056', 'AJ-P2-316057', 'AJ-P2-316058', 'AJ-P2-316059', 'AJ-P2-316060', 'AJ-P2-316094', 'AJ-P2-316095', 'AJ-P2-316096', 'AJ-P2-316097', 'AJ-P2-316098', 'AJ-P2-316099', 'AJ-P2-316100', 'AJ-P2-316101', 'AJ-P2-316102', 'AJ-P2-316103', 'AJ-P2-316104', 'AJ-P2-316105', 'AJ-P2-316106', 'AJ-P2-316107', 'AJ-P2-316108', 'AJ-P2-316109', 'AJ-P2-316110', 'AJ-P2-316111', 'AJ-P2-316112', 'AJ-P2-316113', 'AJ-P2-316114', 'AJ-P2-316115', 'AJ-P2-316116', 'AJ-P2-316117', 'AJ-P2-316118', 'AJ-P2-316119', 'AJ-P2-316120', 'AJ-P2-316121', 'AJ-P2-316122', 'AJ-P2-316123', 'AJ-P2-316124', 'AJ-P2-316125', 'AJ-P2-316126', 'INT-308989-11', 'GCO-308989-11', 'INT-308997-11' ) FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T19:24:21.067570 select * FROM ra_customer_trx_all where trx_number in ('INT-308831-11', 'GCO-308831-11', 'C-337200-07-650976-2', 'C-343026-01-658101-2', 'C-340454-03-661523-2', 'AJ-12-286', 'AJ-12-285', 'INT-313314-11', 'INT-306818-11', 'INT-312678-11', 'INT-306737-11')--,'AJ-1B-831672') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T19:17:47.379672 select * FROM ra_customer_trx_all where trx_number in ('AR-311510-10', 'AR-312948-10', 'AR-315745-10', 'AR-315862-10', 'AJ-61-1537', 'AJ-61-313152', 'AJ-61-313559', 'AJ-61-313560', 'AJ-61-313561', 'AJ-61-313562', 'AJ-61-313563', 'AJ-61-313564', 'AJ-61-313565', 'AJ-61-313566', 'AJ-61-313567', 'AJ-61-313568', 'AJ-61-313569', 'AJ-61-313570', 'AJ-61-313571', 'AJ-61-313572', 'AJ-61-313573', 'AJ-61-313574', 'AJ-61-313575', 'AJ-61-313576', 'AJ-61-313577', 'AJ-61-313578', 'AJ-61-313579', 'AJ-61-313580', 'AJ-61-313581', 'AJ-61-313582', 'AJ-61-313583', 'AJ-61-313584', 'AJ-61-313585', 'AJ-61-313586', 'AJ-61-313587', 'AJ-61-313588', 'AJ-61-313589', 'AJ-61-313590', 'AJ-61-313591', 'AJ-61-313592', 'AJ-61-313593', 'AJ-61-313594', 'AJ-61-313595', 'AJ-61-313596', 'AJ-61-313597', 'AJ-61-313598', 'AJ-61-313599', 'AJ-61-313600', 'AJ-61-313601', 'AJ-61-313602', 'AJ-61-313603', 'AJ-61-313604', 'AJ-61-313605', 'AJ-61-313606', 'AJ-61-313607', 'AJ-61-313608', 'AJ-61-313609', 'AJ-61-313610', 'AJ-61-313611', 'AJ-61-313612', 'AJ-61-313613', 'AJ-61-313614', 'AJ-61-313615', 'AJ-61-313616', 'AJ-61-313617', 'AJ-61-313618', 'AJ-1B-831672') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T18:59:37.562925 select * FROM ra_customer_trx_all where trx_number like 'AR-311510-09' union select * FROM ra_customer_trx_all where trx_number like 'AR-315745-09' union select * FROM ra_customer_trx_all where trx_number like 'AR-312810-10' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T18:58:51.242086 select * FROM ra_customer_trx_all where trx_number like '%AR-311510-09%' union select * FROM ra_customer_trx_all where trx_number like '%AR-315745-09%' union select * FROM ra_customer_trx_all where trx_number like '%AR-312810-10%' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-07T17:47:57.076111 select * FROM ra_customer_trx_all where trx_number in ('INT-327673-03', 'GCO-327673-03', 'AR-307169-09', 'AR-307169-10', 'AR-312356-09', 'AR-312356-10', 'C-21670088-51749-1', 'C-313007-10-614910-2', 'C-312356-01-614154-2', 'C-312356-01-614239-2', 'C-312356-01-614265-2', 'C-314060-01-614424-2', 'C-314060-02-614423-2', 'C-314060-03-614422-2', 'C-314060-04-614421-2', 'C-314060-05-614420-2', 'C-314060-06-614419-2', 'C-314060-07-614418-2', 'C-327077-01-613475-2', 'C-327077-01-613476-2', 'AR-307479-09', 'AR-307479-10', 'AR-313007-09', 'AR-313007-10') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T21:21:38.705556 SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.APPROVERS, T.INITIATED_BY, T.INITIATED_DATE FROM FND_BPM_TASK_VL T WHERE T.PACKAGE_NAME = 'prc' AND T.COMPOSITE_NAME = 'PrcPorManageReqApprovalComposite' AND T.TASK_DEFINITION_NAME = 'ReqApproval' AND ( DBMS_LOB.SUBSTR(T.TASK_TITLE, 4000, 1) LIKE '%SC-4426%' OR DBMS_LOB.SUBSTR(T.IDENTIFICATION_KEY, 4000, 1) LIKE '%300000020926414%' ) ORDER BY T.INITIATED_DATE DESC -- Consulta registrada el 2026-04-01T21:21:05.670513 SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.APPROVERS, T.INITIATED_BY, T.INITIATED_DATE FROM FND_BPM_TASK_VL T WHERE T.PACKAGE_NAME = 'prc' AND T.COMPOSITE_NAME = 'PrcPorManageReqApprovalComposite' AND T.TASK_DEFINITION_NAME = 'ReqApproval' AND T.INITIATED_DATE >= TO_TIMESTAMP('2026-03-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND T.INITIATED_DATE < TO_TIMESTAMP('2026-03-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ORDER BY T.INITIATED_DATE DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T21:20:39.777133 SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.PACKAGE_NAME, T.COMPOSITE_NAME, T.TASK_DEFINITION_NAME, T.APPROVERS, T.INITIATED_BY, T.INITIATED_DATE FROM FND_BPM_TASK_VL T WHERE T.PACKAGE_NAME = 'prc' AND T.COMPOSITE_NAME = 'PrcPorManageReqApprovalComposite' AND T.TASK_DEFINITION_NAME = 'ReqApproval' ORDER BY T.INITIATED_DATE DESC FETCH FIRST 50 ROWS ONLY -- Consulta registrada el 2026-04-01T21:07:02.495616 WITH TASK_REQ AS ( SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.APPROVERS, T.INITIATED_BY, T.INITIATED_DATE, ROW_NUMBER() OVER ( ORDER BY T.INITIATED_DATE DESC ) AS RN FROM POR_REQUISITION_HEADERS_ALL RH JOIN FND_BPM_TASK_VL T ON T.PACKAGE_NAME = 'prc' AND T.COMPOSITE_NAME = 'PrcPorManageReqApprovalComposite' AND T.TASK_DEFINITION_NAME = 'ReqApproval' AND T.IDENTIFICATION_KEY LIKE 'REQ_' || TO_CHAR(RH.REQUISITION_HEADER_ID) || '\_%' ESCAPE '\' WHERE RH.REQUISITION_NUMBER = 'SC-4426' ) SELECT TR.TASK_ID, TR.TASK_TITLE, TR.IDENTIFICATION_KEY, TR.STATUS_CODE, TR.APPROVERS, A.ASSIGNEE, A.ASSIGNEE_TYPE, A.ASSIGNEE_GROUP_OR_ROLE, A.ORIGINAL_ASSIGNEE_USER, A.SEQUENCE, A.INITIATED_DATE FROM TASK_REQ TR LEFT JOIN FND_BPM_TASK_ASSIGNEE A ON A.TASK_ID = TR.TASK_ID WHERE TR.RN = 1 ORDER BY A.VERSION DESC, A.SEQUENCE -- Consulta registrada el 2026-04-01T21:06:40.163985 SELECT RH.REQUISITION_NUMBER, RH.REQUISITION_HEADER_ID, RH.DOCUMENT_STATUS, T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.APPROVERS, T.INITIATED_BY, T.INITIATED_DATE FROM POR_REQUISITION_HEADERS_ALL RH LEFT JOIN FND_BPM_TASK_VL T ON T.PACKAGE_NAME = 'prc' AND T.COMPOSITE_NAME = 'PrcPorManageReqApprovalComposite' AND T.TASK_DEFINITION_NAME = 'ReqApproval' AND T.IDENTIFICATION_KEY LIKE 'REQ_' || TO_CHAR(RH.REQUISITION_HEADER_ID) || '\_%' ESCAPE '\' WHERE RH.REQUISITION_NUMBER = 'SC-4426' ORDER BY T.INITIATED_DATE DESC -- Consulta registrada el 2026-04-01T21:04:18.543165 SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.PACKAGE_NAME, T.COMPOSITE_NAME, T.TASK_DEFINITION_NAME, T.APPROVERS, T.INITIATED_BY, T.INITIATED_DATE FROM FND_BPM_TASK_VL T WHERE T.INITIATED_DATE >= TO_TIMESTAMP('2026-03-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND T.INITIATED_DATE < TO_TIMESTAMP('2026-03-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND NVL(T.PACKAGE_NAME, 'X') <> 'hcm' AND NVL(T.COMPOSITE_NAME, 'X') <> 'HcmCommonCoreAlertsComposite' AND NVL(T.TASK_DEFINITION_NAME, 'X') <> 'HcmEmailNotificationHumantask' ORDER BY T.INITIATED_DATE DESC FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T21:03:58.601677 SELECT T.PACKAGE_NAME, T.COMPOSITE_NAME, T.TASK_DEFINITION_NAME, T.STATUS_CODE, COUNT(*) AS CANTIDAD FROM FND_BPM_TASK_VL T WHERE T.INITIATED_DATE >= TO_TIMESTAMP('2026-03-30 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND T.INITIATED_DATE < TO_TIMESTAMP('2026-03-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS') GROUP BY T.PACKAGE_NAME, T.COMPOSITE_NAME, T.TASK_DEFINITION_NAME, T.STATUS_CODE ORDER BY CANTIDAD DESC -- Consulta registrada el 2026-04-01T20:53:21.138604 SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.CATEGORY, T.COMPOSITE_NAME, T.TASK_DEFINITION_NAME, T.PACKAGE_NAME, T.APPROVERS, T.INITIATED_DATE FROM FND_BPM_TASK_VL T WHERE UPPER(T.TASK_TITLE) LIKE UPPER('%APROBACI%DOCUMENTOS DE COMPRA%') ORDER BY T.INITIATED_DATE DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T20:50:39.963465 SELECT T.TASK_ID, T.TASK_TITLE, T.IDENTIFICATION_KEY, T.STATUS_CODE, T.PACKAGE_NAME, T.INITIATED_BY, T.INITIATED_DATE, T.APPROVERS FROM FND_BPM_TASK_VL T WHERE ROWNUM <= 20 -- Consulta registrada el 2026-04-01T20:42:58.465535 SELECT COUNT(*) FROM FND_BPM_TASK_HISTORY_TL -- Consulta registrada el 2026-04-01T20:42:46.292601 SELECT COUNT(*) FROM FND_BPM_TASK_ASSIGNEE -- Consulta registrada el 2026-04-01T20:42:33.610484 SELECT COUNT(*) FROM FND_BPM_TASK_VL -- Consulta registrada el 2026-04-01T20:24:45.754644 SELECT RH.REQUISITION_NUMBER, RH.DOCUMENT_STATUS, PAH.PERFORMER_ID, PPNA.DISPLAY_NAME, PAH.ACTION_CODE, PAH.ASSIGNMENT_DATE, PAH.ACTION_DATE, PAH.SEQUENCE_NUM FROM POR_REQUISITION_HEADERS_ALL RH JOIN PO_ACTION_HISTORY PAH ON PAH.OBJECT_ID = RH.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNA ON PPNA.PERSON_ID = PAH.PERFORMER_ID WHERE RH.REQUISITION_NUMBER = 'SC-4426' ORDER BY PAH.SEQUENCE_NUM, PAH.ACTION_DATE, PAH.ASSIGNMENT_DATE -- Consulta registrada el 2026-04-01T20:20:32.850347 SELECT RH.REQUISITION_NUMBER, RH.PREPARER_ID, PPREP.DISPLAY_NAME AS PREPARER_NAME, PAH.PERFORMER_ID, PPAH.DISPLAY_NAME AS HISTORY_PERSON_NAME, PAH.ROLE_CODE, PAH.ACTION_CODE, PAH.ASSIGNMENT_DATE, PAH.ACTION_DATE, PAH.SEQUENCE_NUM, PAH.OBJECT_TYPE_CODE, PAH.NOTE FROM POR_REQUISITION_HEADERS_ALL RH JOIN PO_ACTION_HISTORY PAH ON PAH.OBJECT_ID = RH.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPREP ON PPREP.PERSON_ID = RH.PREPARER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPAH ON PPAH.PERSON_ID = PAH.PERFORMER_ID WHERE RH.REQUISITION_NUMBER = 'SC-4397' ORDER BY PAH.SEQUENCE_NUM, PAH.ACTION_DATE, PAH.ASSIGNMENT_DATE -- Consulta registrada el 2026-04-01T19:54:39.787257 SELECT RH.REQUISITION_NUMBER, RH.PREPARER_ID, PPREP.DISPLAY_NAME AS PREPARER_NAME, PAH.PERFORMER_ID, PPAH.DISPLAY_NAME AS HISTORY_PERSON_NAME, PAH.ROLE_CODE, PAH.ACTION_CODE, PAH.ASSIGNMENT_DATE, PAH.ACTION_DATE, PAH.SEQUENCE_NUM, PAH.OBJECT_TYPE_CODE, PAH.NOTE FROM POR_REQUISITION_HEADERS_ALL RH JOIN PO_ACTION_HISTORY PAH ON PAH.OBJECT_ID = RH.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPREP ON PPREP.PERSON_ID = RH.PREPARER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPAH ON PPAH.PERSON_ID = PAH.PERFORMER_ID WHERE RH.REQUISITION_NUMBER = 'SC-4403' ORDER BY PAH.SEQUENCE_NUM, PAH.ACTION_DATE, PAH.ASSIGNMENT_DATE -- Consulta registrada el 2026-04-01T19:50:58.073810 SELECT RH.REQUISITION_NUMBER, RH.PREPARER_ID, PPREP.DISPLAY_NAME AS PREPARER_NAME, PAH.PERFORMER_ID, PPAH.DISPLAY_NAME AS HISTORY_PERSON_NAME, PAH.ROLE_CODE, PAH.ACTION_CODE, PAH.ASSIGNMENT_DATE, PAH.ACTION_DATE, PAH.SEQUENCE_NUM, PAH.OBJECT_TYPE_CODE, PAH.NOTE FROM POR_REQUISITION_HEADERS_ALL RH JOIN PO_ACTION_HISTORY PAH ON PAH.OBJECT_ID = RH.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPREP ON PPREP.PERSON_ID = RH.PREPARER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPAH ON PPAH.PERSON_ID = PAH.PERFORMER_ID WHERE RH.REQUISITION_NUMBER = 'SC-4426' ORDER BY PAH.SEQUENCE_NUM, PAH.ACTION_DATE, PAH.ASSIGNMENT_DATE -- Consulta registrada el 2026-04-01T19:28:52.577038 SELECT RH.REQUISITION_NUMBER, PAH.PERFORMER_ID, PPNA.DISPLAY_NAME FROM POR_REQUISITION_HEADERS_ALL RH JOIN PO_ACTION_HISTORY PAH ON PAH.OBJECT_ID = RH.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNA ON PPNA.PERSON_ID = PAH.PERFORMER_ID WHERE RH.REQUISITION_NUMBER = 'SC-4426' AND ROWNUM <= 20 -- Consulta registrada el 2026-04-01T19:28:28.416266 SELECT PAH.PERFORMER_ID, PPNA.DISPLAY_NAME FROM PO_ACTION_HISTORY PAH LEFT JOIN PER_PERSON_NAMES_F_V PPNA ON PPNA.PERSON_ID = PAH.PERFORMER_ID WHERE ROWNUM <= 10 -- Consulta registrada el 2026-04-01T19:28:10.849950 SELECT PERSON_ID, DISPLAY_NAME FROM PER_PERSON_NAMES_F_V WHERE ROWNUM <= 10 -- Consulta registrada el 2026-04-01T19:27:50.765417 SELECT OBJECT_ID, OBJECT_TYPE_CODE, PERFORMER_ID, ROLE_CODE, ASSIGNMENT_DATE, ACTION_DATE, SEQUENCE_NUM FROM PO_ACTION_HISTORY WHERE ROWNUM <= 10 -- Consulta registrada el 2026-04-01T19:27:27.188981 SELECT COUNT(*) FROM PO_ACTION_HISTORY -- Consulta registrada el 2026-04-01T19:21:23.637963 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), REQ_PENDING_APPROVER_BASE AS ( SELECT DISTINCT PAH.OBJECT_ID AS REQUISITION_HEADER_ID, PAH.PERFORMER_ID, PPNA.DISPLAY_NAME AS PENDING_APPROVER_NAME, PAH.SEQUENCE_NUM, PAH.ASSIGNMENT_DATE FROM PO_ACTION_HISTORY PAH LEFT JOIN PER_PERSON_NAMES_F_V PPNA ON PPNA.PERSON_ID = PAH.PERFORMER_ID AND TRUNC(SYSDATE) BETWEEN PPNA.EFFECTIVE_START_DATE AND PPNA.EFFECTIVE_END_DATE WHERE PAH.OBJECT_TYPE_CODE = 'REQ' AND PAH.ROLE_CODE = 'APPROVER' AND PAH.ASSIGNMENT_DATE IS NOT NULL AND PAH.ACTION_DATE IS NULL ), REQ_PENDING_APPROVER AS ( SELECT REQUISITION_HEADER_ID, LISTAGG(PENDING_APPROVER_NAME, ' | ') WITHIN GROUP (ORDER BY SEQUENCE_NUM, PENDING_APPROVER_NAME) AS PENDING_APPROVER_NAME, LISTAGG(TO_CHAR(PERFORMER_ID), ' | ') WITHIN GROUP (ORDER BY SEQUENCE_NUM, PERFORMER_ID) AS PENDING_APPROVER_ID FROM REQ_PENDING_APPROVER_BASE GROUP BY REQUISITION_HEADER_ID ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RH.JUSTIFICATION AS NOTE_TO_APPROVER, RPA.PENDING_APPROVER_ID, RPA.PENDING_APPROVER_NAME, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.NOTE_TO_SUPPLIER, RL.QUANTITY, RL.UOM_CODE, RL.CURRENCY_CODE, RL.RATE_TYPE, RL.RATE_DATE, RL.RATE, RL.CURRENCY_UNIT_PRICE, RL.UNIT_PRICE, RL.CURRENCY_AMOUNT, RL.AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.VENDOR_CONTACT_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.PERCENT, PRD.DISTRIBUTION_AMOUNT, PRD.DISTRIBUTION_CURRENCY_AMOUNT, PRD.RECOVERABLE_TAX, PRD.NONRECOVERABLE_TAX, PRD.RECOVERABLE_CURRENCY_TAX, PRD.NONRECOVERABLE_CURRENCY_TAX, PRD.CODE_COMBINATION_ID, PRD.ACCOUNT_USER_OVERRIDE_FLAG, LFS.MEANING AS FUNDS_STATUS, PRD.BUDGET_DATE, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = RL.REQUESTER_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = PRD.FUNDS_STATUS AND LFS.RN = 1 LEFT JOIN REQ_PENDING_APPROVER RPA ON RPA.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID where RH.REQUISITION_NUMBER = 'SC-4426' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T19:18:52.730207 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), REQ_PENDING_APPROVER_BASE AS ( SELECT DISTINCT PAH.OBJECT_ID AS REQUISITION_HEADER_ID, PAH.PERFORMER_ID, PPNA.DISPLAY_NAME AS PENDING_APPROVER_NAME, PAH.SEQUENCE_NUM, PAH.ASSIGNMENT_DATE FROM PO_ACTION_HISTORY PAH LEFT JOIN PER_PERSON_NAMES_F_V PPNA ON PPNA.PERSON_ID = PAH.PERFORMER_ID AND TRUNC(SYSDATE) BETWEEN PPNA.EFFECTIVE_START_DATE AND PPNA.EFFECTIVE_END_DATE WHERE PAH.OBJECT_TYPE_CODE = 'REQ' AND PAH.ROLE_CODE = 'APPROVER' AND PAH.ASSIGNMENT_DATE IS NOT NULL AND PAH.ACTION_DATE IS NULL ), REQ_PENDING_APPROVER AS ( SELECT REQUISITION_HEADER_ID, LISTAGG(PENDING_APPROVER_NAME, ' | ') WITHIN GROUP (ORDER BY SEQUENCE_NUM, PENDING_APPROVER_NAME) AS PENDING_APPROVER_NAME, LISTAGG(TO_CHAR(PERFORMER_ID), ' | ') WITHIN GROUP (ORDER BY SEQUENCE_NUM, PERFORMER_ID) AS PENDING_APPROVER_ID FROM REQ_PENDING_APPROVER_BASE GROUP BY REQUISITION_HEADER_ID ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RH.JUSTIFICATION AS NOTE_TO_APPROVER, RPA.PENDING_APPROVER_ID, RPA.PENDING_APPROVER_NAME, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.NOTE_TO_SUPPLIER, RL.QUANTITY, RL.UOM_CODE, RL.CURRENCY_CODE, RL.RATE_TYPE, RL.RATE_DATE, RL.RATE, RL.CURRENCY_UNIT_PRICE, RL.UNIT_PRICE, RL.CURRENCY_AMOUNT, RL.AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.VENDOR_CONTACT_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.PERCENT, PRD.DISTRIBUTION_AMOUNT, PRD.DISTRIBUTION_CURRENCY_AMOUNT, PRD.RECOVERABLE_TAX, PRD.NONRECOVERABLE_TAX, PRD.RECOVERABLE_CURRENCY_TAX, PRD.NONRECOVERABLE_CURRENCY_TAX, PRD.CODE_COMBINATION_ID, PRD.ACCOUNT_USER_OVERRIDE_FLAG, LFS.MEANING AS FUNDS_STATUS, PRD.BUDGET_DATE, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = RL.REQUESTER_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = PRD.FUNDS_STATUS AND LFS.RN = 1 LEFT JOIN REQ_PENDING_APPROVER RPA ON RPA.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T18:30:10.061346 select distinct resource_source_name from PJF_PROJ_TEAM_MEMBERS_V order by 1 --where RESOURCE_SOURCE_NAME like 'Bay%' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:27:36.924287 select distinct resource_source_name from PJF_PROJ_TEAM_MEMBERS_V --where RESOURCE_SOURCE_NAME like 'Bay%' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:27:14.821317 select * from PJF_PROJ_TEAM_MEMBERS_V --where RESOURCE_SOURCE_NAME like 'Bay%' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:24:26.755127 select * from PJF_PROJ_TEAM_MEMBERS_V where RESOURCE_SOURCE_NAME like 'Bay%' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:23:53.224489 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.RESOURCE_SOURCE_ID, PPN.FULL_NAME AS RESOURCE_SOURCE_NAME, PPP.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJECT_PARTIES PPP LEFT JOIN PJT_PROJECT_ROLES_VL R ON PPP.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPN ON PPN.PERSON_ID = PPP.RESOURCE_SOURCE_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PPN.EFFECTIVE_START_DATE) AND TRUNC(PPN.EFFECTIVE_END_DATE) LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = PPP.RESOURCE_SOURCE_ID AND LOWER(EA.EMAIL_ADDRESS) = 'diego.vergara@uai.cl' WHERE PPP.PROJECT_PARTY_TYPE = 'IN' AND PPP.PROJECT_ID = '300000014599118' AND EA.EMAIL_ADDRESS IS NOT NULL FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T18:23:16.753031 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.RESOURCE_SOURCE_ID, PPN.FULL_NAME AS RESOURCE_SOURCE_NAME, PPP.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJECT_PARTIES PPP LEFT JOIN PJT_PROJECT_ROLES_VL R ON PPP.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPN ON PPN.PERSON_ID = PPP.RESOURCE_SOURCE_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PPN.EFFECTIVE_START_DATE) AND TRUNC(PPN.EFFECTIVE_END_DATE) LEFT JOIN PER_ALL_PEOPLE_F PAPF ON PAPF.PERSON_ID = PPP.RESOURCE_SOURCE_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PAPF.EFFECTIVE_START_DATE) AND TRUNC(PAPF.EFFECTIVE_END_DATE) LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.EMAIL_ADDRESS_ID = PAPF.PRIMARY_EMAIL_ID WHERE PPP.PROJECT_PARTY_TYPE = 'IN' AND PPP.PROJECT_ID = '300000014599118' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T18:22:58.242113 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.RESOURCE_SOURCE_ID, PPN.FULL_NAME AS RESOURCE_SOURCE_NAME, PPP.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJECT_PARTIES PPP LEFT JOIN PJT_PROJECT_ROLES_VL R ON PPP.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPN ON PPN.PERSON_ID = PPP.RESOURCE_SOURCE_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PPN.EFFECTIVE_START_DATE) AND TRUNC(PPN.EFFECTIVE_END_DATE) LEFT JOIN PER_ALL_PEOPLE_F PAPF ON PAPF.PERSON_ID = PPP.RESOURCE_SOURCE_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PAPF.EFFECTIVE_START_DATE) AND TRUNC(PAPF.EFFECTIVE_END_DATE) LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.EMAIL_ADDRESS_ID = PAPF.PRIMARY_EMAIL_ID WHERE PPP.PROJECT_PARTY_TYPE = 'IN' AND PPP.PROJECT_ID = '300000014599118' AND LOWER(EA.EMAIL_ADDRESS) = 'diego.vergara@uai.cl' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T18:17:39.436852 SELECT PAA.PERSON_ID, PAA.ASSIGNMENT_ID, PAA.PRIMARY_FLAG, PAA.ASSIGNMENT_TYPE, PAA.ASSIGNMENT_STATUS_TYPE, PAA.ORGANIZATION_ID, PAA.EFFECTIVE_START_DATE, PAA.EFFECTIVE_END_DATE FROM PER_ALL_ASSIGNMENTS_F PAA WHERE PAA.PERSON_ID = '300000011505864' AND DATE '2026-01-01' BETWEEN TRUNC(PAA.EFFECTIVE_START_DATE) AND TRUNC(PAA.EFFECTIVE_END_DATE) ORDER BY PAA.EFFECTIVE_START_DATE DESC FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-04-01T18:17:23.085587 SELECT PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.RESOURCE_SOURCE_ID, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, PPN.PERSON_ID AS PPN_PERSON_ID, PPN.FULL_NAME, PAA.ASSIGNMENT_ID, PAA.PRIMARY_FLAG, PAA.ASSIGNMENT_TYPE, PAA.ASSIGNMENT_STATUS_TYPE, PAA.ORGANIZATION_ID, PAA.EFFECTIVE_START_DATE AS PAA_EFFECTIVE_START_DATE, PAA.EFFECTIVE_END_DATE AS PAA_EFFECTIVE_END_DATE, HRO.ORGANIZATION_ID AS HRO_ORGANIZATION_ID, HRO.STATUS AS HRO_STATUS, HRO.EFFECTIVE_START_DATE AS HRO_EFFECTIVE_START_DATE, HRO.EFFECTIVE_END_DATE AS HRO_EFFECTIVE_END_DATE, CASE WHEN PPN.PERSON_ID IS NULL THEN 'NO_MATCH_PPN' WHEN PAA.ASSIGNMENT_ID IS NULL THEN 'NO_MATCH_PAA' WHEN NVL(PAA.PRIMARY_FLAG,'N') <> 'Y' THEN 'PRIMARY_FLAG_NOT_Y' WHEN NVL(PAA.ASSIGNMENT_TYPE,'X') NOT IN ('E','C') THEN 'ASSIGNMENT_TYPE_NOT_EC' WHEN NVL(PAA.ASSIGNMENT_STATUS_TYPE,'X') NOT IN ('ACTIVE','SUSPENDED') THEN 'ASSIGNMENT_STATUS_NOT_VALID' WHEN HRO.ORGANIZATION_ID IS NULL THEN 'NO_MATCH_HRO' WHEN NVL(HRO.STATUS,'X') <> 'A' THEN 'HRO_STATUS_NOT_A' ELSE 'SHOULD_APPEAR_IN_VIEW' END AS DIAG_RESULT FROM PJF_PROJECT_PARTIES PPP LEFT JOIN PER_PERSON_NAMES_F_V PPN ON PPP.RESOURCE_SOURCE_ID = PPN.PERSON_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PPN.EFFECTIVE_START_DATE) AND TRUNC(PPN.EFFECTIVE_END_DATE) LEFT JOIN PER_ALL_ASSIGNMENTS_F PAA ON PPP.RESOURCE_SOURCE_ID = PAA.PERSON_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(PAA.EFFECTIVE_START_DATE) AND TRUNC(PAA.EFFECTIVE_END_DATE) LEFT JOIN PER_DEPARTMENTS HRO ON PAA.ORGANIZATION_ID = HRO.ORGANIZATION_ID AND TRUNC(PPP.START_DATE_ACTIVE) BETWEEN TRUNC(HRO.EFFECTIVE_START_DATE) AND TRUNC(HRO.EFFECTIVE_END_DATE) WHERE PPP.PROJECT_ID = '300000014599118' AND PPP.RESOURCE_SOURCE_ID = '300000011505864' AND PPP.PROJECT_PARTY_TYPE = 'IN' FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-04-01T18:14:46.563054 select distinct RESOURCE_SOURCE_NAME from PJF_PROJ_TEAM_MEMBERS_V where RESOURCE_SOURCE_NAME like 'Bay%' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:13:13.435940 select distinct RESOURCE_SOURCE_NAME from PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:12:54.650904 select * from PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T18:12:36.786887 SELECT PAAM.PERSON_ID, PAAM.ASSIGNMENT_ID, PAAM.PRIMARY_ASSIGNMENT_FLAG, PAAM.ASSIGNMENT_TYPE, PAAM.EFFECTIVE_START_DATE, PAAM.EFFECTIVE_END_DATE FROM PER_ALL_ASSIGNMENTS_M PAAM WHERE PAAM.PERSON_ID = '300000011505864' ORDER BY PAAM.EFFECTIVE_START_DATE DESC FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-04-01T17:56:07.874929 --select distinct RESOURCE_SOURCE_NAME from PJF_PROJ_TEAM_MEMBERS_V --select * --from PJF_PROJ_TEAM_MEMBERS_V --where project_id = :project_id -- and resource_source_id = :person_id; select * from PJF_PROJECT_MEMBERS_V --where project_id = :project_id -- and person_id = :person_id; FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T17:53:58.626375 select distinct RESOURCE_SOURCE_NAME from PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T17:38:30.286448 select * from PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T17:37:38.710635 select * from PJF_PROJECT_PARTIES-- PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T17:29:34.007841 SELECT PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.PROJECT_PARTY_TYPE, PPP.RESOURCE_SOURCE_ID, PPP.PROJECT_ROLE_ID, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, PPP.CREATED_BY, PPP.CREATION_DATE FROM PJF_PROJECT_PARTIES PPP WHERE PPP.RESOURCE_SOURCE_ID = '300000011505864' ORDER BY PPP.CREATION_DATE DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T17:29:02.581797 SELECT PAPF.PERSON_ID, PAPF.PERSON_NUMBER, PPN.FULL_NAME, EA.EMAIL_ADDRESS, PAPF.EFFECTIVE_START_DATE, PAPF.EFFECTIVE_END_DATE FROM PER_ALL_PEOPLE_F PAPF LEFT JOIN PER_PERSON_NAMES_F_V PPN ON PPN.PERSON_ID = PAPF.PERSON_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(PPN.EFFECTIVE_START_DATE) AND TRUNC(PPN.EFFECTIVE_END_DATE) LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.EMAIL_ADDRESS_ID = PAPF.PRIMARY_EMAIL_ID WHERE LOWER(EA.EMAIL_ADDRESS) = 'diego.vergara@uai.cl' AND TRUNC(SYSDATE) BETWEEN TRUNC(PAPF.EFFECTIVE_START_DATE) AND TRUNC(PAPF.EFFECTIVE_END_DATE) FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-04-01T17:28:01.748951 SELECT PPP.PROJECT_PARTY_ID, PPP.PROJECT_ID, PPP.OBJECT_ID, PPP.OBJECT_TYPE, PPP.PROJECT_PARTY_TYPE, PPP.RESOURCE_SOURCE_ID, PPP.RESOURCE_ID, PPP.PROJ_RESOURCE_ID, PPP.RELATIONSHIP_ID, PPP.PROJECT_ROLE_ID, PPP.START_DATE_ACTIVE, PPP.END_DATE_ACTIVE, PPP.SCHEDULED_FLAG, PPP.CREATED_BY, PPP.CREATION_DATE, PPP.LAST_UPDATED_BY, PPP.LAST_UPDATE_DATE FROM PJF_PROJECT_PARTIES PPP WHERE PPP.PROJECT_ID = '300000014599118' ORDER BY PPP.CREATION_DATE DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T17:20:44.739555 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID INNER JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID --WHERE EA.EMAIL_ADDRESS LIKE '%diego%' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T17:20:23.810455 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID INNER JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID WHERE EA.EMAIL_ADDRESS LIKE '%felipe%' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T17:12:46.378797 select distinct RESOURCE_SOURCE_NAME from PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T17:12:23.942856 select * from PJF_PROJ_TEAM_MEMBERS_V FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T17:12:03.219994 SELECT * FROM PJF_PROJ_TEAM_MEMBERS_V WHERE RESOURCE_SOURCE_NAME LIKE '%Felipe%' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T17:11:31.590409 SELECT * FROM PJF_PROJ_TEAM_MEMBERS_V --WHERE EA.EMAIL_ADDRESS LIKE '%felipe%' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T17:06:31.669042 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID INNER JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID WHERE EA.EMAIL_ADDRESS LIKE '%felipe%' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-04-01T14:49:39.761329 SELECT object_type_code, object_sub_type_code, COUNT(*) FROM po_action_history GROUP BY object_type_code, object_sub_type_code ORDER BY 1,2 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T14:46:27.464291 select * from po_action_history fetch first 100 rows only -- Consulta registrada el 2026-04-01T14:45:27.472334 SELECT pah.object_id, pah.object_type_code, pah.object_sub_type_code, pah.sequence_num, pah.action_code, pah.action_date, pah.assignment_date, pah.performer_id, pah.role_code, pah.note, pah.object_revision_num, pah.po_version_id, pah.parent_version_id FROM po_action_history pah WHERE pah.object_id = 300000010249864 AND pah.object_type_code = 'PO' FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T14:41:17.170420 SELECT pah.object_id, pah.object_type_code, pah.object_sub_type_code, pah.sequence_num, pah.action_code, pah.action_date, pah.assignment_date, pah.performer_id, pah.role_code, pah.note, pah.object_revision_num, pah.po_version_id, pah.parent_version_id FROM po_action_history pah WHERE pah.object_id = 300000010249864 AND pah.object_type_code = 'PO' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T14:40:48.793987 SELECT pah.object_id, pah.object_type_code, pah.object_sub_type_code, pah.sequence_num, pah.action_code, pah.action_date, pah.assignment_date, pah.performer_id, pah.role_code, pah.note, pah.object_revision_num, pah.po_version_id, pah.parent_version_id FROM po_action_history pah WHERE pah.object_id = 300000010249864 --:po_header_id AND pah.object_type_code = 'PO' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T14:40:15.307124 SELECT po_header_id, segment1, type_lookup_code FROM po_headers_all WHERE segment1 = 'OC-908' -- :po_number; FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T14:38:57.003041 SELECT po_header_id, segment1, type_lookup_code FROM po_headers_all --WHERE segment1 = :po_number; FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T14:36:17.917436 SELECT object_type_code, object_sub_type_code, COUNT(*) FROM po_action_history GROUP BY object_type_code, object_sub_type_code ORDER BY 1,2 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T14:16:35.859155 select * from po_action_history FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-04-01T13:37:16.442154 select * from FND_BPM_TASK_B FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T13:32:05.963358 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, PDA.CODE_COMBINATION_ID AS PO_CODE_COMBINATION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID, AID.INVOICE_ID, AID.INVOICE_DISTRIBUTION_ID, AID.INVOICE_LINE_NUMBER, AID.DIST_CODE_COMBINATION_ID AS AP_DIST_CODE_COMBINATION_ID, AI.INVOICE_NUM, AI.INVOICE_DATE, AI.INVOICE_AMOUNT, AI.INVOICE_CURRENCY_CODE, AI.PAYMENT_STATUS_FLAG FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN PO_DISTRIBUTIONS_ALL PDA ON PDA.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 LEFT JOIN AP_INVOICE_DISTRIBUTIONS_ALL AID ON AID.RCV_TRANSACTION_ID = RT.TRANSACTION_ID LEFT JOIN AP_INVOICES_ALL AI ON AI.INVOICE_ID = AID.INVOICE_ID WHERE RSH.RECEIPT_NUM = 3228 AND LKP.MEANING = 'Recibir' FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T13:29:45.461894 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), FACTURA_POR_RECEPCION AS ( SELECT AID.RCV_TRANSACTION_ID, AID.INVOICE_ID, MIN(AID.INVOICE_DISTRIBUTION_ID) AS INVOICE_DISTRIBUTION_ID, MIN(AID.INVOICE_LINE_NUMBER) AS INVOICE_LINE_NUMBER, MIN(AID.DIST_CODE_COMBINATION_ID) AS AP_DIST_CODE_COMBINATION_ID, COUNT(*) AS AP_DISTRIBUTION_COUNT FROM AP_INVOICE_DISTRIBUTIONS_ALL AID WHERE AID.RCV_TRANSACTION_ID IS NOT NULL GROUP BY AID.RCV_TRANSACTION_ID, AID.INVOICE_ID ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, PDA.CODE_COMBINATION_ID AS PO_CODE_COMBINATION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID, FPR.INVOICE_ID, FPR.INVOICE_DISTRIBUTION_ID, FPR.INVOICE_LINE_NUMBER, FPR.AP_DIST_CODE_COMBINATION_ID, FPR.AP_DISTRIBUTION_COUNT, AI.INVOICE_NUM, AI.INVOICE_DATE, AI.INVOICE_AMOUNT, AI.INVOICE_CURRENCY_CODE, AI.PAYMENT_STATUS_FLAG FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN PO_DISTRIBUTIONS_ALL PDA ON PDA.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 LEFT JOIN FACTURA_POR_RECEPCION FPR ON FPR.RCV_TRANSACTION_ID = RT.TRANSACTION_ID LEFT JOIN AP_INVOICES_ALL AI ON AI.INVOICE_ID = FPR.INVOICE_ID WHERE RSH.RECEIPT_NUM = 3228 AND LKP.MEANING = 'Recibir' ORDER BY RT.TRANSACTION_DATE, AI.INVOICE_DATE, AI.INVOICE_NUM -- Consulta registrada el 2026-04-01T13:28:43.567372 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, PDA.CODE_COMBINATION_ID AS PO_CODE_COMBINATION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID, AID.INVOICE_ID, AID.INVOICE_DISTRIBUTION_ID, AID.INVOICE_LINE_NUMBER, AID.DIST_CODE_COMBINATION_ID AS AP_DIST_CODE_COMBINATION_ID, AI.INVOICE_NUM, AI.INVOICE_DATE, AI.INVOICE_AMOUNT, AI.INVOICE_CURRENCY_CODE, AI.PAYMENT_STATUS_FLAG FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = (select rt.po_header_id from rcv_transactions where invoice_id is not null) LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN PO_DISTRIBUTIONS_ALL PDA ON PDA.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 LEFT JOIN AP_INVOICE_DISTRIBUTIONS_ALL AID ON AID.RCV_TRANSACTION_ID = RT.TRANSACTION_ID LEFT JOIN AP_INVOICES_ALL AI ON AI.INVOICE_ID = AID.INVOICE_ID WHERE RSH.RECEIPT_NUM = 3228 FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T13:18:09.096277 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, PDA.CODE_COMBINATION_ID AS PO_CODE_COMBINATION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID, AID.INVOICE_ID, AID.INVOICE_DISTRIBUTION_ID, AID.INVOICE_LINE_NUMBER, AID.DIST_CODE_COMBINATION_ID AS AP_DIST_CODE_COMBINATION_ID, AI.INVOICE_NUM, AI.INVOICE_DATE, AI.INVOICE_AMOUNT, AI.INVOICE_CURRENCY_CODE, AI.PAYMENT_STATUS_FLAG FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN PO_DISTRIBUTIONS_ALL PDA ON PDA.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 LEFT JOIN AP_INVOICE_DISTRIBUTIONS_ALL AID ON AID.RCV_TRANSACTION_ID = RT.TRANSACTION_ID LEFT JOIN AP_INVOICES_ALL AI ON AI.INVOICE_ID = AID.INVOICE_ID WHERE RSH.RECEIPT_NUM = 3228 FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T13:13:55.444587 SELECT RT.TRANSACTION_ID AS RCV_TRANSACTION_ID, PH.SEGMENT1 AS PO_NUMBER, RSH.RECEIPT_NUM, CRT.CMR_RCV_TRANSACTION_ID, CRT.EXTERNAL_SYSTEM_REF_ID, CRE.ACCOUNTING_EVENT_ID, CRE.EVENT_TYPE_CODE, CRE.ACCOUNTED_FLAG, CRE.SOURCE_DOC_NUMBER, CRE.SLA_TRANSACTION_NUMBER, CRE.EVENT_SOURCE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN CMR_RCV_TRANSACTIONS CRT ON CRT.EXTERNAL_SYSTEM_REFERENCE = 'FUSION' AND CRT.EXTERNAL_SYSTEM_REF_ID = TO_CHAR(RT.TRANSACTION_ID) LEFT JOIN CMR_RCV_EVENTS CRE ON CRE.CMR_RCV_TRANSACTION_ID = CRT.CMR_RCV_TRANSACTION_ID WHERE RSH.RECEIPT_NUM = 3228 FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T13:12:15.439211 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 WHERE PH.SEGMENT1 = 'OC-3076' FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T13:11:34.450806 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T13:06:41.192719 SELECT RT.TRANSACTION_ID, PH.SEGMENT1 AS PO_NUMBER, RSH.RECEIPT_NUM, CRE.ACCOUNTING_EVENT_ID, CRE.CMR_RCV_TRANSACTION_ID, CRE.SOURCE_DOC_NUMBER, CRE.SLA_TRANSACTION_NUMBER, CRE.EVENT_TYPE_CODE, CRE.ACCOUNTED_FLAG FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN CMR_RCV_EVENTS CRE ON CRE.CMR_RCV_TRANSACTION_ID = RT.TRANSACTION_ID WHERE RSH.RECEIPT_NUM = 3228 FETCH FIRST 200 ROWS ONLY -- Consulta registrada el 2026-04-01T13:03:33.179044 SELECT * FROM CMR_RCV_EVENTS cre WHERE CMR_RCV_TRANSACTION_ID is not null FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T13:02:28.054947 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, PDA.CODE_COMBINATION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN PO_DISTRIBUTIONS_ALL PDA ON PDA.PO_DISTRIBUTION_ID = RT.PO_DISTRIBUTION_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 WHERE RSH.RECEIPT_NUM = 3228 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:59:20.016467 SELECT * FROM CMR_RCV_EVENTS cre WHERE CMR_RCV_TRANSACTION_ID is not null FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:58:46.436936 SELECT * FROM CMR_RCV_EVENTS cre WHERE CMR_RCV_TRANSACTION_ID = 65480 --WHERE cre.cmr_rcv_transaction_id IN (65480, 65479) --where RSH.RECEIPT_NUM = 3228 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:58:16.855576 SELECT * FROM CMR_RCV_EVENTS cre order by CMR_RCV_TRANSACTION_ID asc --WHERE cre.cmr_rcv_transaction_id IN (65480, 65479) --where RSH.RECEIPT_NUM = 3228 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:58:09.360164 SELECT * FROM CMR_RCV_EVENTS cre order by CMR_RCV_TRANSACTION_ID desc --WHERE cre.cmr_rcv_transaction_id IN (65480, 65479) --where RSH.RECEIPT_NUM = 3228 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:56:31.072509 SELECT * FROM CMR_RCV_EVENTS cre --WHERE cre.cmr_rcv_transaction_id IN (65480, 65479) --where RSH.RECEIPT_NUM = 3228 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:48:54.764539 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 where RSH.RECEIPT_NUM = 3228 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:42:28.855496 SELECT * FROM CMR_RCV_DISTRIBUTIONS where CREATED_BY NOT LIKE 'aramis@uai.cl' FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:40:59.104081 SELECT * FROM CMR_RCV_DISTRIBUTIONS FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:35:47.266581 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T12:17:05.622591 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-04-01T11:25:46.902834 SELECT * from FND_VS_VALUES_B where VALUE = '214702' fetch first 10 rows only -- Consulta registrada el 2026-04-01T11:22:25.801004 SELECT * from FND_VS_VALUES_B fetch first 10 rows only -- Consulta registrada el 2026-04-01T11:15:12.851845 SELECT * FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta Financiera UAI' ) and FLEX_VALUE = '214702' fetch first 10 rows only -- Consulta registrada el 2026-04-01T11:14:19.313287 SELECT * FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta Financiera UAI' ) and FLEX_VALUE = '331304' fetch first 10 rows only -- Consulta registrada el 2026-04-01T11:13:34.777117 SELECT * FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta Financiera UAI' -- tabla independiente ) fetch first 10 rows only -- Consulta registrada el 2026-03-31T20:58:54.749649 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID INNER JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID WHERE EA.EMAIL_ADDRESS LIKE '%felipe%' FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-31T20:57:22.335040 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID where PROJECT_MEMBER_EMAIL = 'diego.vergara@uai.cl' fetch first 10 rows only -- Consulta registrada el 2026-03-31T20:56:58.136352 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID fetch first 10 rows only -- Consulta registrada el 2026-03-31T20:56:08.008501 SELECT R.ENTERPRISE_ID, R.PROJECT_ROLE_ID, R.NAME, R.IS_SEEDED, R.CREATED_BY, R.CREATION_DATE, R.LAST_UPDATED_BY, R.LAST_UPDATE_DATE, R.LAST_UPDATE_LOGIN, R.OBJECT_VERSION_NUMBER, TM.PROJECT_PARTY_ID, TM.PROJECT_ID, TM.RESOURCE_SOURCE_ID, TM.RESOURCE_SOURCE_NAME, TM.PROJECT_ROLE_ID AS TM_PROJECT_ROLE_ID, TM.START_DATE_ACTIVE, TM.END_DATE_ACTIVE, EA.EMAIL_ADDRESS AS PROJECT_MEMBER_EMAIL FROM PJF_PROJ_TEAM_MEMBERS_V TM LEFT JOIN PJT_PROJECT_ROLES_VL R ON TM.PROJECT_ROLE_ID = R.PROJECT_ROLE_ID LEFT JOIN PER_EMAIL_ADDRESSES EA ON EA.PERSON_ID = TM.RESOURCE_SOURCE_ID FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T13:41:32.494109 --select * from AP_INVOICES_INTERFACE where vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' 'ROBERTO ARNALDO LARENAS PINOCHET ' --select * from AP_INVOICE_LINES_INTERFACE where invoice_id = 237 select * from AP_INTERFACE_REJECTIONS FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T13:40:04.000160 --select * from AP_INVOICES_INTERFACE where vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' 'ROBERTO ARNALDO LARENAS PINOCHET ' select * from AP_INVOICE_LINES_INTERFACE where invoice_id = 237 --select * from AP_INTERFACE_REJECTIONS FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T13:39:10.859273 --select * from AP_INVOICES_INTERFACE where vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' 'ROBERTO ARNALDO LARENAS PINOCHET ' --select * from AP_INVOICE_LINES_INTERFACE where invoice_id = 237 select * from AP_INTERFACE_REJECTIONS FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T13:36:12.551006 --select * from AP_INVOICES_INTERFACE where vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' 'ROBERTO ARNALDO LARENAS PINOCHET ' select * from AP_INVOICE_LINES_INTERFACE where invoice_id = 237 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T13:29:15.358019 select * from AP_INVOICES_INTERFACE where vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T13:26:41.088809 select * from AP_INVOICES_INTERFACE where invoice_num ='237' --vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T12:42:51.092543 select * from AP_INVOICES_INTERFACE where vendor_name ='ROBERTO ARNALDO LARENAS PINOCHET' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T12:40:08.519495 select * from AP_INVOICES_INTERFACE where invoice_num = '237' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T12:39:26.628911 select * from AP_INVOICES_INTERFACE FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-31T12:35:03.519750 select * from AP_INTERFACE_REJECTIONS FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-30T14:07:23.154397 SELECT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME, GCC.SEGMENT3 AS CUENTA_GESTION, COUNT(*) AS VECES FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID LEFT JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID LEFT JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' LEFT JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' JOIN POR_REQUISITION_LINES_ALL RL ON RL.ITEM_ID = B.INVENTORY_ITEM_ID JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN GL_CODE_COMBINATIONS GCC ON GCC.CODE_COMBINATION_ID = PRD.CODE_COMBINATION_ID WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' GROUP BY B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME, GCC.SEGMENT3 ORDER BY B.ITEM_NUMBER, VECES DESC FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-30T13:57:29.324047 SELECT distinct B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.ITEM_NUMBER LIKE '%SERV%' ORDER BY B.ITEM_NUMBER DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-30T13:55:40.221735 SELECT * FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.ITEM_NUMBER LIKE '%SERV%' ORDER BY B.ITEM_NUMBER DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-30T13:54:39.676328 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.SALES_ACCOUNT DESC FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-30T13:54:20.664704 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.SALES_ACCOUNT DESC FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-30T13:53:20.609097 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER, B.SALES_ACCOUNT DESC FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-30T13:53:09.796231 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER, B.SALES_ACCOUNT ASC FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-30T13:42:41.751020 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER, B.SALES_ACCOUNT FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-30T13:41:36.467644 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, B.SALES_ACCOUNT, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-30T13:37:22.475733 SELECT * FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-27T20:46:34.269480 SELECT COUNT(*) FROM AP_INVOICES_ALL AIA JOIN AP_INVOICE_LINES_ALL AIL ON AIL.INVOICE_ID = AIA.INVOICE_ID FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T20:45:29.999330 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 fetch first 100 rows only -- Consulta registrada el 2026-03-27T20:40:21.588283 --whereselect -- * --from fusion.fnd_bpm_task_composites_b --where task_definition_name = 'FinExmWorkflowExpenseApproval' -- SELECT ER.EXPENSE_REPORT_TOTAL, ER.PURPOSE, ER.REIMBURSEMENT_CURRENCY_CODE, ER.REPORT_SUBMIT_DATE,'FIN_ITEMS_COLLECTION' as FIN_ITEMS_COLLECTION FROM FUSION.EXM_EXPENSE_REPORTS ER --where ER.EXPENSE_REPORT_ID = :ID_KEY select * from rcv_transactions FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T20:38:41.795327 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 fetch first 100 rows only -- Consulta registrada el 2026-03-27T20:36:15.310411 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, H.NOTE_TO_VENDOR AS HEADER_NOTE_TO_VENDOR, H.NOTE_TO_RECEIVER, H.COMMENTS AS HEADER_COMMENTS, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.NOTE_TO_VENDOR AS LINE_NOTE_TO_VENDOR, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, COALESCE(PRH.REQUISITION_NUMBER, POD.REQ_HEADER_REFERENCE_NUM, 'No Aplica') AS REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, CASE WHEN PRL.LINE_NUMBER IS NOT NULL THEN PRL.LINE_NUMBER ELSE NULL END AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = POD.DELIVER_TO_PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 WHERE NVL(LL.QUANTITY, 0) <> NVL(LL.QUANTITY_RECEIVED, 0) and OSS.MEANING = 'Abierta' FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-27T20:35:36.987338 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, H.NOTE_TO_VENDOR AS HEADER_NOTE_TO_VENDOR, H.NOTE_TO_RECEIVER, H.COMMENTS AS HEADER_COMMENTS, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.NOTE_TO_VENDOR AS LINE_NOTE_TO_VENDOR, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, COALESCE(PRH.REQUISITION_NUMBER, POD.REQ_HEADER_REFERENCE_NUM, 'No Aplica') AS REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, CASE WHEN PRL.LINE_NUMBER IS NOT NULL THEN PRL.LINE_NUMBER ELSE NULL END AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = POD.DELIVER_TO_PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 WHERE NVL(LL.QUANTITY, 0) <> NVL(LL.QUANTITY_RECEIVED, 0) and OSS.MEANING = 'Abierta' FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:20:19.941177 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, H.NOTE_TO_VENDOR AS HEADER_NOTE_TO_VENDOR, H.NOTE_TO_RECEIVER, H.COMMENTS AS HEADER_COMMENTS, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.NOTE_TO_VENDOR AS LINE_NOTE_TO_VENDOR, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, COALESCE(PRH.REQUISITION_NUMBER, POD.REQ_HEADER_REFERENCE_NUM, 'No Aplica') AS REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, CASE WHEN PRL.LINE_NUMBER IS NOT NULL THEN PRL.LINE_NUMBER ELSE NULL END AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = POD.DELIVER_TO_PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 WHERE NVL(LL.QUANTITY, 0) <> NVL(LL.QUANTITY_RECEIVED, 0) FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:14:42.646752 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, H.NOTE_TO_VENDOR AS HEADER_NOTE_TO_VENDOR, H.NOTE_TO_RECEIVER, H.COMMENTS AS HEADER_COMMENTS, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.NOTE_TO_VENDOR AS LINE_NOTE_TO_VENDOR, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, COALESCE(PRH.REQUISITION_NUMBER, POD.REQ_HEADER_REFERENCE_NUM, 'No Aplica') AS REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, CASE WHEN PRL.LINE_NUMBER IS NOT NULL THEN PRL.LINE_NUMBER ELSE NULL END AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = POD.DELIVER_TO_PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:12:21.347727 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.SEGMENT1 AS PO_NUMBER, OSH.MEANING AS DOCUMENT_STATUS, L.PO_LINE_ID, L.LINE_NUM AS PO_LINE_NUMBER, OLS.MEANING AS LINE_STATUS, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, OSS.MEANING AS SCHEDULE_STATUS, POD.PO_DISTRIBUTION_ID, LFS.MEANING AS FUNDS_STATUS, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:09:18.007536 select * FROM AP_INVOICE_LINES_ALL FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:09:00.715258 select * FROM AP_INVOICES_ALL FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:01:09.965498 SELECT AIA.INVOICE_ID, AIA.INVOICE_NUM, AIA.INVOICE_DATE, AIA.CURRENCY_CODE, AIA.INVOICE_TYPE_LOOKUP_CODE, AIA.VENDOR_ID, AIA.VENDOR_SITE_ID, AIL.LINE_NUMBER, AIL.LINE_TYPE_LOOKUP_CODE, AIL.DESCRIPTION, AIL.AMOUNT, AIL.BASE_AMOUNT, AIL.QUANTITY_INVOICED, AIL.UNIT_PRICE, AIL.INVENTORY_ITEM_ID, AIL.PO_HEADER_ID, AIL.PO_LINE_LOCATION_ID, AIL.RCV_TRANSACTION_ID, AIL.DISCARDED_FLAG, AIL.CANCELLED_FLAG, AIL.ACCOUNTING_DATE, AIL.PREPAY_INVOICE_ID FROM AP_INVOICES_ALL AIA JOIN AP_INVOICE_LINES_ALL AIL ON AIL.INVOICE_ID = AIA.INVOICE_ID FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T20:00:48.285742 SELECT DISTINCT AIL.LINE_TYPE_LOOKUP_CODE FROM AP_INVOICE_LINES_ALL AIL ORDER BY AIL.LINE_TYPE_LOOKUP_CODE FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T19:46:53.025351 WITH LKP_APPROVAL_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'NLS TRANSLATION' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT AIA.INVOICE_ID, AIA.INVOICE_NUM, AIA.INVOICE_DATE, AIA.INVOICE_AMOUNT, AIA.AMOUNT_PAID, AIA.INVOICE_TYPE_LOOKUP_CODE, AIA.APPROVAL_STATUS AS APPROVAL_STATUS_CODE, LKP_APP.MEANING AS APPROVAL_STATUS, AIA.PAYMENT_STATUS_FLAG, AIA.VENDOR_ID, AIA.VENDOR_SITE_ID, AIA.CREATED_BY, AIA.CREATION_DATE, AID.INVOICE_DISTRIBUTION_ID, AID.INVOICE_LINE_NUMBER, AID.DISTRIBUTION_LINE_NUMBER, AID.AMOUNT AS DISTRIBUTION_AMOUNT, AID.QUANTITY_INVOICED, AID.MATCH_STATUS_FLAG, AID.POSTED_FLAG, AID.PO_DISTRIBUTION_ID, AID.RCV_TRANSACTION_ID, AID.DIST_CODE_COMBINATION_ID, POD.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, POD.PO_LINE_ID, POD.LINE_LOCATION_ID FROM AP_INVOICES_ALL AIA JOIN AP_INVOICE_DISTRIBUTIONS_ALL AID ON AID.INVOICE_ID = AIA.INVOICE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = POD.PO_HEADER_ID LEFT JOIN LKP_APPROVAL_STATUS LKP_APP ON LKP_APP.LOOKUP_CODE = AIA.APPROVAL_STATUS AND LKP_APP.RN = 1 FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T19:35:12.038407 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.SEGMENT1 AS PO_NUMBER, OSH.MEANING AS DOCUMENT_STATUS, L.PO_LINE_ID, L.LINE_NUM AS PO_LINE_NUMBER, OLS.MEANING AS LINE_STATUS, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, OSS.MEANING AS SCHEDULE_STATUS, POD.PO_DISTRIBUTION_ID, LFS.MEANING AS FUNDS_STATUS, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T19:34:11.497814 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.SEGMENT1 AS PO_NUMBER, OSH.MEANING AS DOCUMENT_STATUS, L.PO_LINE_ID, L.LINE_NUM AS PO_LINE_NUMBER, OLS.MEANING AS LINE_STATUS, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, OSS.MEANING AS SCHEDULE_STATUS, POD.PO_DISTRIBUTION_ID, LFS.MEANING AS FUNDS_STATUS, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 WHERE PRH.REQUISITION_NUMBER IS NOT NULL FETCH FIRST 20 ROWS ONLY -- Consulta registrada el 2026-03-27T19:27:47.542141 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, H.NOTE_TO_VENDOR AS HEADER_NOTE_TO_VENDOR, H.NOTE_TO_RECEIVER, H.COMMENTS AS HEADER_COMMENTS, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.NOTE_TO_VENDOR AS LINE_NOTE_TO_VENDOR, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, LFS.MEANING AS FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, CASE WHEN PRH.REQUISITION_NUMBER IS NULL THEN 'OC Directa' ELSE 'Desde SC' END AS OC_ORIGIN, PRH.REQUISITION_HEADER_ID, COALESCE(PRH.REQUISITION_NUMBER, POD.REQ_HEADER_REFERENCE_NUM, 'No Aplica') AS REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, CASE WHEN PRL.LINE_NUMBER IS NOT NULL THEN PRL.LINE_NUMBER ELSE NULL END AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = POD.DELIVER_TO_PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = POD.FUNDS_STATUS AND LFS.RN = 1 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-27T19:16:11.083353 WITH FUNDS_STATUS_VALS AS ( SELECT DISTINCT POD.FUNDS_STATUS FROM PO_DISTRIBUTIONS_ALL POD WHERE POD.FUNDS_STATUS IS NOT NULL ), MATCHES AS ( SELECT B.LOOKUP_TYPE, COUNT(DISTINCT B.LOOKUP_CODE) AS MATCHED_CODES, LISTAGG(DISTINCT B.LOOKUP_CODE, ', ') WITHIN GROUP (ORDER BY B.LOOKUP_CODE) AS CODES FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' JOIN FUNDS_STATUS_VALS F ON F.FUNDS_STATUS = B.LOOKUP_CODE GROUP BY B.LOOKUP_TYPE ) SELECT LOOKUP_TYPE, MATCHED_CODES, CODES FROM MATCHES ORDER BY MATCHED_CODES DESC, LOOKUP_TYPE FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-27T19:12:03.232397 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, H.NOTE_TO_VENDOR AS HEADER_NOTE_TO_VENDOR, H.NOTE_TO_RECEIVER, H.COMMENTS AS HEADER_COMMENTS, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.NOTE_TO_VENDOR AS LINE_NOTE_TO_VENDOR, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.FUNDS_STATUS, POD.BUDGET_DATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY, PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER AS REQUISITION_LINE_NUMBER FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID LEFT JOIN POR_REQUISITION_LINES_ALL PRL ON PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID LEFT JOIN POR_REQUISITION_HEADERS_ALL PRH ON PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = POD.DELIVER_TO_PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-27T19:06:47.938014 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_FUNDS_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_FUNDS_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RH.JUSTIFICATION AS NOTE_TO_APPROVER, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.NOTE_TO_SUPPLIER, RL.QUANTITY, RL.UOM_CODE, RL.CURRENCY_CODE, RL.RATE_TYPE, RL.RATE_DATE, RL.RATE, RL.CURRENCY_UNIT_PRICE, RL.UNIT_PRICE, RL.CURRENCY_AMOUNT, RL.AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.VENDOR_CONTACT_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.PERCENT, PRD.DISTRIBUTION_AMOUNT, PRD.DISTRIBUTION_CURRENCY_AMOUNT, PRD.RECOVERABLE_TAX, PRD.NONRECOVERABLE_TAX, PRD.RECOVERABLE_CURRENCY_TAX, PRD.NONRECOVERABLE_CURRENCY_TAX, PRD.CODE_COMBINATION_ID, PRD.ACCOUNT_USER_OVERRIDE_FLAG, LFS.MEANING AS FUNDS_STATUS, PRD.BUDGET_DATE, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = RL.REQUESTER_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 LEFT JOIN LKP_FUNDS_STATUS LFS ON LFS.LOOKUP_CODE = PRD.FUNDS_STATUS AND LFS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T18:48:47.264408 WITH FUNDS_STATUS_VALS AS ( SELECT DISTINCT PRD.FUNDS_STATUS FROM POR_REQ_DISTRIBUTIONS_ALL PRD WHERE PRD.FUNDS_STATUS IS NOT NULL ), MATCHES AS ( SELECT B.LOOKUP_TYPE, COUNT(DISTINCT B.LOOKUP_CODE) AS MATCHED_CODES, LISTAGG(DISTINCT B.LOOKUP_CODE, ', ') WITHIN GROUP (ORDER BY B.LOOKUP_CODE) AS CODES FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' JOIN FUNDS_STATUS_VALS F ON F.FUNDS_STATUS = B.LOOKUP_CODE GROUP BY B.LOOKUP_TYPE ) SELECT LOOKUP_TYPE, MATCHED_CODES, CODES FROM MATCHES ORDER BY MATCHED_CODES DESC, LOOKUP_TYPE FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T18:40:15.276739 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RH.JUSTIFICATION AS NOTE_TO_APPROVER, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.NOTE_TO_SUPPLIER, RL.QUANTITY, RL.UOM_CODE, RL.CURRENCY_CODE, RL.RATE_TYPE, RL.RATE_DATE, RL.RATE, RL.CURRENCY_UNIT_PRICE, RL.UNIT_PRICE, RL.CURRENCY_AMOUNT, RL.AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, PPNF.DISPLAY_NAME AS REQUESTER_NAME, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.VENDOR_CONTACT_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.PERCENT, PRD.DISTRIBUTION_AMOUNT, PRD.DISTRIBUTION_CURRENCY_AMOUNT, PRD.RECOVERABLE_TAX, PRD.NONRECOVERABLE_TAX, PRD.RECOVERABLE_CURRENCY_TAX, PRD.NONRECOVERABLE_CURRENCY_TAX, PRD.CODE_COMBINATION_ID, PRD.ACCOUNT_USER_OVERRIDE_FLAG, PRD.FUNDS_STATUS, PRD.BUDGET_DATE, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN PER_PERSON_NAMES_F_V PPNF ON PPNF.PERSON_ID = RL.REQUESTER_ID AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 fetch first 10 rows only -- Consulta registrada el 2026-03-27T18:25:47.927476 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RH.JUSTIFICATION AS NOTE_TO_APPROVER, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.NOTE_TO_SUPPLIER, RL.QUANTITY, RL.UOM_CODE, RL.CURRENCY_CODE, RL.RATE_TYPE, RL.RATE_DATE, RL.RATE, RL.CURRENCY_UNIT_PRICE, RL.UNIT_PRICE, RL.CURRENCY_AMOUNT, RL.AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.VENDOR_CONTACT_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, RL.ASSESSABLE_VALUE, RL.DEFAULT_TAXATION_COUNTRY, RL.TAX_CLASSIFICATION_CODE, RL.TRX_BUSINESS_CATEGORY, RL.USER_DEFINED_FISC_CLASS, RL.PRODUCT_FISC_CLASSIFICATION, RL.LINE_INTENDED_USE, RL.PRODUCT_TYPE, RL.PRODUCT_CATEGORY, RL.TAX_ATTR_USER_OVERRIDE_FLAG, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.PERCENT, PRD.DISTRIBUTION_CURRENCY_AMOUNT, PRD.DISTRIBUTION_AMOUNT, PRD.RECOVERABLE_CURRENCY_TAX, PRD.NONRECOVERABLE_CURRENCY_TAX, PRD.RECOVERABLE_TAX, PRD.NONRECOVERABLE_TAX, PRD.CODE_COMBINATION_ID, PRD.ACCOUNT_USER_OVERRIDE_FLAG, PRD.FUNDS_STATUS, PRD.BUDGET_DATE, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-27T18:04:08.473163 select * from PER_PERSONS_V Fetch first 10 rows only -- Consulta registrada el 2026-03-27T18:03:27.211734 select * from PER_PERSONS FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:28:11.673867 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:23:28.773340 select * from POR_REQ_DISTRIBUTIONS_ALL where REQUISITION_LINE_ID = 300000008606364 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:23:13.558558 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.QUANTITY, RL.UOM_CODE, RL.UNIT_PRICE, RL.AMOUNT, RL.CURRENCY_AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.DISTRIBUTION_AMOUNT, PRD.CODE_COMBINATION_ID, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 WHERE REQUISITION_NUMBER = 'SC-29' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:22:44.278939 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.QUANTITY, RL.UOM_CODE, RL.UNIT_PRICE, RL.AMOUNT, RL.CURRENCY_AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.DISTRIBUTION_AMOUNT, PRD.CODE_COMBINATION_ID, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 --WHERE REQUISITION_NUMBER = 'SC-34' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:21:11.292214 select * from POR_REQ_DISTRIBUTIONS_ALL where REQUISITION_LINE_ID = 300000008624972 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:20:57.782207 select * from POR_REQ_DISTRIBUTIONS_ALL where REQUISITION_LINE_ID = '300000008624972' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:19:19.593283 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.QUANTITY, RL.UOM_CODE, RL.UNIT_PRICE, RL.AMOUNT, RL.CURRENCY_AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.DISTRIBUTION_AMOUNT, PRD.CODE_COMBINATION_ID, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 WHERE REQUISITION_NUMBER = 'SC-34' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T13:07:36.430958 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.QUANTITY, RL.UOM_CODE, RL.UNIT_PRICE, RL.AMOUNT, RL.CURRENCY_AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.DISTRIBUTION_AMOUNT, PRD.CODE_COMBINATION_ID, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 -- Consulta registrada el 2026-03-27T09:06:38.423011 --whereselect -- * --from fusion.fnd_bpm_task_composites_b --where task_definition_name = 'FinExmWorkflowExpenseApproval' SELECT ER.EXPENSE_REPORT_TOTAL, ER.PURPOSE, ER.REIMBURSEMENT_CURRENCY_CODE, ER.REPORT_SUBMIT_DATE,'FIN_ITEMS_COLLECTION' as FIN_ITEMS_COLLECTION FROM FUSION.EXM_EXPENSE_REPORTS ER --where ER.EXPENSE_REPORT_ID = :ID_KEY FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-27T09:04:25.440107 select * from fusion.fnd_bpm_task_composites_b where task_definition_name = 'FinExmWorkflowExpenseApproval' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-26T23:21:13.715345 select * from fusion.fnd_bpm_task_b t where t.task_definition_name = 'FinExmWorkflowExpenseApproval' -- Consulta registrada el 2026-03-26T23:18:17.758316 Select * from FND_BPM_TASK_B -- Consulta registrada el 2026-03-25T19:32:43.249313 SELECT DISTINCT CSTL.CATEGORY_SET_NAME FROM EGP_CATEGORY_SETS_TL CSTL FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T19:31:50.367923 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:31:15.503892 SELECT DISTINCT CTL.CATEGORY_NAME FROM EGP_CATEGORIES_TL CTL FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T19:28:46.508490 SELECT DISTINCT IODV.ORGANIZATION_CODE, B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 100 ROWS ONLY -- Consulta registrada el 2026-03-25T19:28:07.428825 SELECT DISTINCT IODV.ORGANIZATION_CODE, B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:27:43.474012 SELECT DISTINCT IODV.ORGANIZATION_CODE, B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND T.DESCRIPTION LIKE '%INGENIERIA%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:27:03.530484 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' --CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' T.DESCRIPTION LIKE '%INGENIERIA%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:26:27.922410 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' --CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' T.DESCRIPTION LIKE '%RESMA%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:25:42.314141 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND T.DESCRIPTION LIKE '%RESMA%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:25:05.392884 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.DESCRIPTION LIKE '%RES%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:24:46.941949 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.DESCRIPTION LIKE '%RESMA%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:24:06.165276 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.ITEM_NUMBER = '11001-A' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:23:07.342613 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:21:55.888472 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.ITEM_NUMBER LIKE '%SERV10' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:21:37.117975 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE --IODV.ORGANIZATION_CODE = 'MAE' CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.ITEM_NUMBER LIKE '%SERV10%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:19:51.788625 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' AND B.ITEM_NUMBER LIKE '%SERV%' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:18:56.052400 SELECT DISTINCT B.INVENTORY_ITEM_ID, B.ITEM_NUMBER, T.DESCRIPTION, B.ITEM_TYPE, B.INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.PURCHASING_ENABLED_FLAG, ICA.CATEGORY_SET_ID, CSTL.CATEGORY_SET_NAME, ICA.CATEGORY_ID, CTL.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B B JOIN EGP_SYSTEM_ITEMS_TL T ON T.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND T.ORGANIZATION_ID = B.ORGANIZATION_ID AND T.LANGUAGE = 'E' JOIN INV_ORGANIZATION_DEFINITIONS_V IODV ON IODV.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_ITEM_CAT_ASSIGNMENTS ICA ON ICA.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND ICA.ORGANIZATION_ID = B.ORGANIZATION_ID JOIN EGP_CATEGORY_SETS_TL CSTL ON CSTL.CATEGORY_SET_ID = ICA.CATEGORY_SET_ID AND CSTL.LANGUAGE = 'E' JOIN EGP_CATEGORIES_TL CTL ON CTL.CATEGORY_ID = ICA.CATEGORY_ID AND CTL.LANGUAGE = 'E' WHERE IODV.ORGANIZATION_CODE = 'MAE' AND CSTL.CATEGORY_SET_NAME = 'UAI_CATALOGO_COMPRAS' ORDER BY B.ITEM_NUMBER FETCH FIRST 10 ROWS ONLY -- Consulta registrada el 2026-03-25T19:09:38.747233 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T19:03:51.193728 SELECT APS.INVOICE_ID, APS.PAYMENT_NUM, APS.PAYMENT_STATUS_FLAG, APS.AMOUNT_REMAINING, APS.GROSS_AMOUNT, APS.DUE_DATE, APS.HOLD_FLAG, APS.HELD_BY, APS.HOLD_DATE, APS.PAYMENT_METHOD_LOOKUP_CODE, APS.PAYMENT_PRIORITY, APS.DISCOUNT_DATE, APS.DISCOUNT_AMOUNT_AVAILABLE, APS.CREATED_BY, APS.CREATION_DATE FROM AP_PAYMENT_SCHEDULES_ALL APS FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:58:10.488969 WITH LKP_APPROVAL_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'NLS TRANSLATION' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT AIA.INVOICE_ID, AIA.INVOICE_NUM, AIA.INVOICE_DATE, AIA.INVOICE_AMOUNT, AIA.AMOUNT_PAID, AIA.INVOICE_TYPE_LOOKUP_CODE, AIA.APPROVAL_STATUS AS APPROVAL_STATUS_CODE, LKP_APP.MEANING AS APPROVAL_STATUS, AIA.PAYMENT_STATUS_FLAG, AIA.VENDOR_ID, AIA.VENDOR_SITE_ID, AIA.CREATED_BY, AIA.CREATION_DATE, AID.INVOICE_DISTRIBUTION_ID, AID.INVOICE_LINE_NUMBER, AID.DISTRIBUTION_LINE_NUMBER, AID.AMOUNT AS DISTRIBUTION_AMOUNT, AID.QUANTITY_INVOICED, AID.MATCH_STATUS_FLAG, AID.POSTED_FLAG, AID.PO_DISTRIBUTION_ID, AID.RCV_TRANSACTION_ID, AID.DIST_CODE_COMBINATION_ID, POD.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, POD.PO_LINE_ID, POD.LINE_LOCATION_ID FROM AP_INVOICES_ALL AIA JOIN AP_INVOICE_DISTRIBUTIONS_ALL AID ON AID.INVOICE_ID = AIA.INVOICE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = POD.PO_HEADER_ID LEFT JOIN LKP_APPROVAL_STATUS LKP_APP ON LKP_APP.LOOKUP_CODE = AIA.APPROVAL_STATUS AND LKP_APP.RN = 1 WHERE PH.SEGMENT1 = 'OC-132616' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:54:48.132579 WITH LKP_APPROVAL_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'NLS TRANSLATION' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT AIA.INVOICE_ID, AIA.INVOICE_NUM, AIA.INVOICE_DATE, AIA.INVOICE_AMOUNT, AIA.AMOUNT_PAID, AIA.INVOICE_TYPE_LOOKUP_CODE, AIA.APPROVAL_STATUS AS APPROVAL_STATUS_CODE, LKP_APP.MEANING AS APPROVAL_STATUS, AIA.PAYMENT_STATUS_FLAG, AIA.VENDOR_ID, AIA.VENDOR_SITE_ID, AIA.CREATED_BY, AIA.CREATION_DATE, AID.INVOICE_DISTRIBUTION_ID, AID.INVOICE_LINE_NUMBER, AID.DISTRIBUTION_LINE_NUMBER, AID.AMOUNT AS DISTRIBUTION_AMOUNT, AID.QUANTITY_INVOICED, AID.MATCH_STATUS_FLAG, AID.POSTED_FLAG, AID.PO_DISTRIBUTION_ID, AID.RCV_TRANSACTION_ID, AID.DIST_CODE_COMBINATION_ID, POD.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, POD.PO_LINE_ID, POD.LINE_LOCATION_ID FROM AP_INVOICES_ALL AIA JOIN AP_INVOICE_DISTRIBUTIONS_ALL AID ON AID.INVOICE_ID = AIA.INVOICE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_DISTRIBUTION_ID = AID.PO_DISTRIBUTION_ID LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = POD.PO_HEADER_ID LEFT JOIN LKP_APPROVAL_STATUS LKP_APP ON LKP_APP.LOOKUP_CODE = AIA.APPROVAL_STATUS AND LKP_APP.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:44:06.767037 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 WHERE RT.PO_DISTRIBUTION_ID IN ('43', '44') FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:42:06.820616 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 WHERE RT.PO_DISTRIBUTION_ID = '43' FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:40:39.896860 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:38:53.537510 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 WHERE H.SEGMENT1 LIKE '%132616%' ORDER BY HEADER_CREATION_DATE DESC FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:34:21.606282 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.QUANTITY, RL.UOM_CODE, RL.UNIT_PRICE, RL.AMOUNT, RL.CURRENCY_AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.DISTRIBUTION_AMOUNT, PRD.CODE_COMBINATION_ID, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:31:37.406963 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 ORDER BY HEADER_CREATION_DATE DESC FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:27:49.053983 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:25:11.025084 WITH LKP_RCV_TRANSACTION_TYPE AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'RCV_TRANSACTION_TYPE' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RT.TRANSACTION_ID, LKP.MEANING AS TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY, RT.UOM_CODE, RT.PO_HEADER_ID, PH.SEGMENT1 AS PO_NUMBER, RT.PO_LINE_ID, RT.PO_LINE_LOCATION_ID, RT.PO_DISTRIBUTION_ID, RT.REQUISITION_LINE_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RSH.RECEIPT_NUM, RSH.EXPECTED_RECEIPT_DATE, RSH.EMPLOYEE_ID AS RECEIPT_EMPLOYEE_ID FROM RCV_TRANSACTIONS RT LEFT JOIN PO_HEADERS_ALL PH ON PH.PO_HEADER_ID = RT.PO_HEADER_ID LEFT JOIN RCV_SHIPMENT_HEADERS RSH ON RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID LEFT JOIN LKP_RCV_TRANSACTION_TYPE LKP ON LKP.LOOKUP_CODE = RT.TRANSACTION_TYPE AND LKP.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:18:10.662907 WITH LKP_ORDER_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_ORDER_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'ORDER_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT H.PO_HEADER_ID, H.PRC_BU_ID, H.SEGMENT1 AS PO_NUMBER, H.TYPE_LOOKUP_CODE, OSH.MEANING AS DOCUMENT_STATUS, H.APPROVED_FLAG, H.APPROVED_DATE, H.CANCEL_FLAG AS HEADER_CANCEL_FLAG, H.CLOSED_DATE AS HEADER_CLOSED_DATE, H.REVISION_NUM, H.CREATION_DATE AS HEADER_CREATION_DATE, H.CREATED_BY AS HEADER_CREATED_BY, H.LAST_UPDATE_DATE AS HEADER_LAST_UPDATE_DATE, H.AGENT_ID, H.VENDOR_ID, H.VENDOR_SITE_ID, H.VENDOR_CONTACT_ID, H.CURRENCY_CODE, H.RATE_TYPE, H.RATE_DATE, H.RATE, H.TERMS_ID, L.PO_LINE_ID, L.LINE_NUM, L.ITEM_ID, L.CATEGORY_ID, L.ITEM_DESCRIPTION, L.UOM_CODE AS LINE_UOM_CODE, L.QUANTITY AS LINE_QUANTITY, L.UNIT_PRICE, OLS.MEANING AS LINE_STATUS, L.LINE_TYPE_ID, L.LIST_PRICE_PER_UNIT, L.AMOUNT_RELEASED, L.CREATION_DATE AS LINE_CREATION_DATE, L.CREATED_BY AS LINE_CREATED_BY, L.LAST_UPDATE_DATE AS LINE_LAST_UPDATE_DATE, L.LAST_UPDATED_BY AS LINE_LAST_UPDATED_BY, LL.LINE_LOCATION_ID, LL.SHIPMENT_NUM, LL.SHIPMENT_TYPE, OSS.MEANING AS SCHEDULE_STATUS, LL.QUANTITY AS SCHEDULE_QUANTITY, LL.QUANTITY_RECEIVED, LL.QUANTITY_ACCEPTED, LL.QUANTITY_REJECTED, LL.QUANTITY_BILLED, LL.QUANTITY_CANCELLED, LL.UOM_CODE AS SCHEDULE_UOM_CODE, LL.PRICE_OVERRIDE, LL.NEED_BY_DATE, LL.PROMISED_DATE, LL.CANCEL_FLAG AS SCHEDULE_CANCEL_FLAG, LL.SHIPMENT_CLOSED_DATE, LL.CLOSED_FOR_RECEIVING_DATE, LL.CLOSED_FOR_INVOICE_DATE, LL.CLOSED_DATE AS SCHEDULE_CLOSED_DATE, LL.CLOSED_BY AS SCHEDULE_CLOSED_BY, LL.CLOSED_REASON AS SCHEDULE_CLOSED_REASON, LL.CREATION_DATE AS SCHEDULE_CREATION_DATE, LL.CREATED_BY AS SCHEDULE_CREATED_BY, LL.LAST_UPDATE_DATE AS SCHEDULE_LAST_UPDATE_DATE, LL.LAST_UPDATED_BY AS SCHEDULE_LAST_UPDATED_BY, POD.PO_DISTRIBUTION_ID, POD.REQ_DISTRIBUTION_ID, POD.REQ_HEADER_REFERENCE_NUM, POD.REQ_LINE_REFERENCE_NUM, POD.CODE_COMBINATION_ID, POD.QUANTITY_ORDERED, POD.QUANTITY_DELIVERED, POD.QUANTITY_BILLED AS DIST_QUANTITY_BILLED, POD.QUANTITY_CANCELLED AS DIST_QUANTITY_CANCELLED, POD.AMOUNT_BILLED, POD.DELIVER_TO_LOCATION_ID, POD.DELIVER_TO_PERSON_ID, POD.RATE_DATE AS DIST_RATE_DATE, POD.RATE AS DIST_RATE, POD.CREATION_DATE AS DIST_CREATION_DATE, POD.CREATED_BY AS DIST_CREATED_BY FROM PO_HEADERS_ALL H LEFT JOIN PO_LINES_ALL L ON L.PO_HEADER_ID = H.PO_HEADER_ID LEFT JOIN PO_LINE_LOCATIONS_ALL LL ON LL.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID LEFT JOIN PO_DISTRIBUTIONS_ALL POD ON POD.PO_HEADER_ID = H.PO_HEADER_ID AND POD.PO_LINE_ID = L.PO_LINE_ID AND POD.LINE_LOCATION_ID = LL.LINE_LOCATION_ID LEFT JOIN LKP_ORDER_STATUS OSH ON OSH.LOOKUP_CODE = NVL(H.DOCUMENT_STATUS, 'INCOMPLETE') AND OSH.RN = 1 LEFT JOIN LKP_ORDER_LINE_STATUS OLS ON OLS.LOOKUP_CODE = L.LINE_STATUS AND OLS.RN = 1 LEFT JOIN LKP_ORDER_STATUS OSS ON OSS.LOOKUP_CODE = NVL(LL.SCHEDULE_STATUS, 'INCOMPLETE') AND OSS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-03-25T18:10:19.190732 WITH LKP_REQ_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_DOCUMENT_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ), LKP_REQ_LINE_STATUS AS ( SELECT B.LOOKUP_CODE, TL.MEANING, ROW_NUMBER() OVER ( PARTITION BY B.LOOKUP_TYPE, B.LOOKUP_CODE ORDER BY B.SET_ID, B.VIEW_APPLICATION_ID ) AS RN FROM FND_LOOKUP_VALUES_B B JOIN FND_LOOKUP_VALUES_TL TL ON TL.LOOKUP_TYPE = B.LOOKUP_TYPE AND TL.LOOKUP_CODE = B.LOOKUP_CODE AND TL.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND TL.SET_ID = B.SET_ID AND TL.ENTERPRISE_ID = B.ENTERPRISE_ID AND TL.SANDBOX_ID = B.SANDBOX_ID AND TL.LANGUAGE = 'E' WHERE B.LOOKUP_TYPE = 'POR_LINE_STATUS' AND B.ENABLED_FLAG = 'Y' AND (B.START_DATE_ACTIVE IS NULL OR B.START_DATE_ACTIVE <= SYSDATE) AND (B.END_DATE_ACTIVE IS NULL OR B.END_DATE_ACTIVE >= SYSDATE) ) SELECT RH.REQUISITION_HEADER_ID, RH.REQUISITION_NUMBER, RH.REQ_BU_ID, RHS.MEANING AS DOCUMENT_STATUS, RH.PREPARER_ID, RH.SUBMISSION_DATE, RH.CREATED_BY, RH.APPROVED_DATE, RH.DESCRIPTION AS REQ_DESCRIPTION, RL.REQUISITION_LINE_ID, RL.LINE_NUMBER, RLS.MEANING AS LINE_STATUS, RL.ITEM_ID, RL.ITEM_DESCRIPTION, RL.QUANTITY, RL.UOM_CODE, RL.UNIT_PRICE, RL.AMOUNT, RL.CURRENCY_AMOUNT, RL.NEED_BY_DATE, RL.REQUESTER_ID, RL.VENDOR_ID, RL.VENDOR_SITE_ID, RL.REQS_IN_POOL_FLAG, RL.PO_HEADER_ID, RL.PO_LINE_ID, RL.DESTINATION_ORGANIZATION_ID, PRD.DISTRIBUTION_ID, PRD.DISTRIBUTION_NUMBER, PRD.DISTRIBUTION_QUANTITY, PRD.DISTRIBUTION_AMOUNT, PRD.CODE_COMBINATION_ID, PRD.CREATION_DATE AS DISTRIBUTION_CREATION_DATE, PRD.CREATED_BY AS DISTRIBUTION_CREATED_BY FROM POR_REQUISITION_HEADERS_ALL RH JOIN POR_REQUISITION_LINES_ALL RL ON RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID LEFT JOIN POR_REQ_DISTRIBUTIONS_ALL PRD ON PRD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID LEFT JOIN LKP_REQ_STATUS RHS ON RHS.LOOKUP_CODE = NVL(RH.DOCUMENT_STATUS, 'INCOMPLETE') AND RHS.RN = 1 LEFT JOIN LKP_REQ_LINE_STATUS RLS ON RLS.LOOKUP_CODE = RL.LINE_STATUS AND RLS.RN = 1 FETCH FIRST 999 ROWS ONLY -- Consulta registrada el 2026-02-06T01:15:43.197985 select * from dual -- Consulta registrada el 2025-09-29T17:26:14.544689 SELECT RTRIM(LTRIM(ROW_ID)) AS ROW_ID, RTRIM(LTRIM(LOOKUP_TYPE)) AS LOOKUP_TYPE, RTRIM(LTRIM(LOOKUP_CODE)) AS LOOKUP_CODE, RTRIM(LTRIM(MEANING)) AS MEANING, RTRIM(LTRIM(DESCRIPTION)) AS DESCRIPTION, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, RTRIM(LTRIM(CREATED_BY)) AS CREATED_BY, TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') AS CREATION_DATE, RTRIM(LTRIM(LAST_UPDATED_BY)) AS LAST_UPDATED_BY, TO_CHAR(LAST_UPDATE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS LAST_UPDATE_DATE, RTRIM(LTRIM(ATTRIBUTE1)) AS ATTRIBUTE1, -- full (y/n) RTRIM(LTRIM(ATTRIBUTE2)) AS ATTRIBUTE2, -- area RTRIM(LTRIM(ATTRIBUTE3)) AS ATTRIBUTE3, -- sub area RTRIM(LTRIM(ATTRIBUTE4)) AS ATTRIBUTE4, -- centro de costo RTRIM(LTRIM(ATTRIBUTE5)) AS ATTRIBUTE5 -- cuenta gestion FROM fnd_lookup_values_vl WHERE LOOKUP_TYPE = 'UAI_SEGURIDAD_REPORTES' AND ENABLED_FLAG = 'Y' -- Consulta registrada el 2025-09-29T15:52:24.195400 SELECT row_id, flex_value, flex_value_id, enabled_flag, start_date_active, end_date_active, value_category, attribute1, -- atributo de Centro de Costo: es centro ej: el ces, cefis attribute2, -- atributo de Centro de Costo: tipo de area ej: academica o administrativa attribute3, -- atributo de Centro de Costo: area relacionado con la linea area attribute4, -- atributo de Centro de Costo: sub area attribute5, -- atributo de Centro de Costo: tipo programa attribute6, -- atributo de Centro de Costo: subtipo porgrama attribute7, -- atributo de Centro de Costo: sede attribute8, -- atributo de Centro de Costo: con auxliar attribute9, -- atributo de Centro de Costo: nota ifrs attribute10, -- atributo de Centro de Costo: nota ses attribute11, -- atributo de Centro de Costo: sub grupo ses attribute12, -- atributo de Centro de Costo: forma consolidado gestion attribute13, -- atributo de Centro de Costo: forma consolidado ifrs attribute14, -- atributo de Centro de Costo: forma consolidado ses last_update_date, description, creation_date FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta de Gestion UAI' -- tabla independiente ) and enabled_flag = 'Y' and flex_value_id = '89077' -- Consulta registrada el 2025-09-29T15:51:12.365053 SELECT row_id, flex_value, flex_value_id, enabled_flag, start_date_active, end_date_active, value_category, attribute1, -- atributo de Centro de Costo: es centro ej: el ces, cefis attribute2, -- atributo de Centro de Costo: tipo de area ej: academica o administrativa attribute3, -- atributo de Centro de Costo: area relacionado con la linea area attribute4, -- atributo de Centro de Costo: sub area attribute5, -- atributo de Centro de Costo: tipo programa attribute6, -- atributo de Centro de Costo: subtipo porgrama attribute7, -- atributo de Centro de Costo: sede attribute8, -- atributo de Centro de Costo: con auxliar attribute9, -- atributo de Centro de Costo: nota ifrs attribute10, -- atributo de Centro de Costo: nota ses attribute11, -- atributo de Centro de Costo: sub grupo ses attribute12, -- atributo de Centro de Costo: forma consolidado gestion attribute13, -- atributo de Centro de Costo: forma consolidado ifrs attribute14, -- atributo de Centro de Costo: forma consolidado ses last_update_date, description, creation_date FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta de Gestion UAI' -- tabla independiente ) and enabled_flag = 'Y' and flex_value_id = '89059' -- Consulta registrada el 2025-09-29T15:50:40.172740 SELECT row_id, flex_value, flex_value_id, enabled_flag, start_date_active, end_date_active, value_category, attribute1, -- atributo de Centro de Costo: es centro ej: el ces, cefis attribute2, -- atributo de Centro de Costo: tipo de area ej: academica o administrativa attribute3, -- atributo de Centro de Costo: area relacionado con la linea area attribute4, -- atributo de Centro de Costo: sub area attribute5, -- atributo de Centro de Costo: tipo programa attribute6, -- atributo de Centro de Costo: subtipo porgrama attribute7, -- atributo de Centro de Costo: sede attribute8, -- atributo de Centro de Costo: con auxliar attribute9, -- atributo de Centro de Costo: nota ifrs attribute10, -- atributo de Centro de Costo: nota ses attribute11, -- atributo de Centro de Costo: sub grupo ses attribute12, -- atributo de Centro de Costo: forma consolidado gestion attribute13, -- atributo de Centro de Costo: forma consolidado ifrs attribute14, -- atributo de Centro de Costo: forma consolidado ses last_update_date, description, creation_date FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta de Gestion UAI' -- tabla independiente ) and enabled_flag = 'Y' and flex_value_id = '89056' -- Consulta registrada el 2025-09-29T15:49:10.780628 SELECT row_id, flex_value, flex_value_id, enabled_flag, start_date_active, end_date_active, value_category, attribute1, -- atributo de Centro de Costo: es centro ej: el ces, cefis attribute2, -- atributo de Centro de Costo: tipo de area ej: academica o administrativa attribute3, -- atributo de Centro de Costo: area relacionado con la linea area attribute4, -- atributo de Centro de Costo: sub area attribute5, -- atributo de Centro de Costo: tipo programa attribute6, -- atributo de Centro de Costo: subtipo porgrama attribute7, -- atributo de Centro de Costo: sede attribute8, -- atributo de Centro de Costo: con auxliar attribute9, -- atributo de Centro de Costo: nota ifrs attribute10, -- atributo de Centro de Costo: nota ses attribute11, -- atributo de Centro de Costo: sub grupo ses attribute12, -- atributo de Centro de Costo: forma consolidado gestion attribute13, -- atributo de Centro de Costo: forma consolidado ifrs attribute14, -- atributo de Centro de Costo: forma consolidado ses last_update_date, description, creation_date FROM FND_FLEX_VALUES_VL WHERE value_category IN ( 'Cuenta de Gestion UAI' -- tabla independiente ) and enabled_flag = 'Y' -- Consulta registrada el 2025-09-29T15:17:17.188186 select * from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_ESTRUCTURA' -- Consulta registrada el 2025-09-29T15:16:05.178964 select * from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_ESTRUCTURA' -- Consulta registrada el 2025-09-29T15:15:38.421088 select concat ('GEST-', LOOKUP_CODE) as ID_CONS, LOOKUP_CODE, MEANING, ENABLED_FLAG, case when ATTRIBUTE1 = '' then '' when ATTRIBUTE1 <> '' then concat ('GEST-', ATTRIBUTE1) else '' end as ID_PADRE, DISPLAY_SEQUENCE, LOOKUP_TYPE, LAST_UPDATE_DATE from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_ESTRUCTURA' -- Consulta registrada el 2025-09-29T15:13:04.182741 select concat ('GEST-', LOOKUP_CODE) as ID_CONS, LOOKUP_CODE, MEANING, ENABLED_FLAG, case when ATTRIBUTE1 = '' then '' when ATTRIBUTE1 <> '' then concat ('GEST-', ATTRIBUTE1) else '' end as ID_PADRE, DISPLAY_SEQUENCE, LOOKUP_TYPE, LAST_UPDATE_DATE from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_FORMAS' -- Consulta registrada el 2025-09-29T15:11:36.030681 select concat ('GEST-', LOOKUP_CODE) as ID_CONS, LOOKUP_CODE, MEANING, ENABLED_FLAG, case when ATTRIBUTE1 = '' then '' when ATTRIBUTE1 <> '' then concat ('GEST-', ATTRIBUTE1) else '' end as ID_PADRE, DISPLAY_SEQUENCE, LOOKUP_TYPE, LAST_UPDATE_DATE from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_ESTRUCTURA' -- Consulta registrada el 2025-09-29T15:02:02.372775 select concat ('GEST-', LOOKUP_CODE) as ID_CONS, LOOKUP_CODE, MEANING, ENABLED_FLAG, case when ATTRIBUTE1 = '' then '' when ATTRIBUTE1 <> '' then concat ('GEST-', ATTRIBUTE1) else '' end as ID_PADRE, DISPLAY_SEQUENCE, LOOKUP_TYPE, LAST_UPDATE_DATE from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_ESTRUCTURA' -- Consulta registrada el 2025-09-29T15:00:55.865971 select concat ('SIES-', LOOKUP_CODE) as ID_CONS, LOOKUP_CODE, MEANING, ENABLED_FLAG, case when ATTRIBUTE1 = '' then '' when ATTRIBUTE1 <> '' then concat ('SIES-', ATTRIBUTE1) else '' end as ID_PADRE, DISPLAY_SEQUENCE, LOOKUP_TYPE, LAST_UPDATE_DATE from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_SIES_ESTRUCTURA' -- Consulta registrada el 2025-09-29T14:58:17.239910 select concat ('GEST-', LOOKUP_CODE) as ID_CONS, LOOKUP_CODE, MEANING, ENABLED_FLAG, case when ATTRIBUTE1 = '' then '' when ATTRIBUTE1 <> '' then concat ('GEST-', ATTRIBUTE1) else '' end as ID_PADRE, DISPLAY_SEQUENCE, LOOKUP_TYPE, LAST_UPDATE_DATE from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE = 'UAI_CONS_GESTION_ESTRUCTURA'