WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
VIS	346991799	VIS	1	24-Sep-12 10:09	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dbzone1	Solaris[tm] OE (64-bit)	256	32	4	255.50

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	27	24-Sep-12 12:12:59	5606	70.1
End Snap:	28	24-Sep-12 12:28:13	5597	71.8
Elapsed:		15.23 (mins)
DB Time:		718.00 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	40,448M	37,888M	Std Block Size:	8K
Shared Pool Size:	102,400M	102,400M	Log Buffer:	718,752K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	47.1	0.1	0.00	0.00
DB CPU(s):	42.4	0.1	0.00	0.00
Redo size:	7,841,462.8	12,642.0
Logical reads:	576,517.0	929.5
Block changes:	49,482.7	79.8
Physical reads:	79.9	0.1
Physical writes:	720.4	1.2
User calls:	15,576.4	25.1
Parses:	3,439.4	5.5
Hard parses:	7.0	0.0
W/A MB processed:	75.8	0.1
Logons:	6.2	0.0
Executes:	41,182.8	66.4
Rollbacks:	99.6	0.2
Transactions:	620.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	100.09	Soft Parse %:	99.80
Execute to Parse %:	91.65	Latch Hit %:	97.49
Parse CPU to Parse Elapsd %:	94.66	% Non-Parse CPU:	96.25

Shared Pool Statistics

	Begin	End
Memory Usage %:	9.33	9.43
% SQL with executions>1:	99.14	98.59
% Memory for SQL w/exec>1:	97.66	96.27

Top 5 Timed Foreground Events

Host CPU (CPUs: 256 Cores: 32 Sockets: 4)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
59.20	60.14	20.0	3.6	0.0	76.5

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
16.7	71.1	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	261,632.0	261,632.0
SGA use (MB):	199,680.0	199,680.0
PGA use (MB):	6,326.9	7,157.3
% Host Mem used for SGA+PGA:	78.74	79.06

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 43080.1s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 110.9% of Total DB time 43,080.09 (s)
• Total FG Wait Time: 8,993.89 (s) DB CPU time: 38,762.65 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 13.7% of Total DB Time (s): 43,080
• Captured PL/SQL account for 43.2% of Total DB Time (s): 43,080

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 14.5% of Total CPU Time (s): 38,763
• Captured PL/SQL account for 41.9% of Total CPU Time (s): 38,763

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 2.2% of Total User I/O Wait Time (s): 54
• Captured PL/SQL account for 49.7% of Total User I/O Wait Time (s): 54

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 526,959,040
• Captured SQL account for 42.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 73,072
• Captured SQL account for 2.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 52,942
• Captured SQL account for 0.7% of Total
• Total UnOptimized Read Requests: 52,942
• Captured SQL account for 0.7% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 37,642,700
• Captured SQL account for 12.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 3,143,701
• Captured SQL account for 27.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0b85w9vv0hbt1	UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
0bujgc94rg3fj	begin WF_EVENT.setNavigationParams ( p_agentName => :1, p_navigationThreshold => :2 ); WF_EVENT.LISTEN ( p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7 );end;
0d3t5pd9c06kx	SELECT NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0), NVL( SUM( NVL(EXTENDED_AMOUNT, 0 ) ), 0) FROM RA_CUSTOMER_TRX_LINES WHERE CUSTOMER_TRX_ID = :B2 AND LINE_TYPE = :B1
0wmwsjy9kd92f	SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
15py3q5vknkb9	BEGIN PO_REQAPPROVAL_INIT1.Start_WF_Process(ItemType => NULL, ItemKey => NULL, WorkflowProcess => NULL, ActionOriginatedFrom => 'PO_FORM', DocumentID => :1, DocumentNumber => :2, PreparerID => :3, DocumentTypeCode => :4, DocumentSubtype => :5, SubmitterAction => 'APPROVE', forwardToID => :6, forwardFromID => :7, DefaultApprovalPathID => :8, Note => :9, PrintFlag => :10, FaxFlag => :11, FaxNumber => :12, EmailFlag => :13, EmailAddress => :14, CreateSourcingRule => :15, UpdateSourcingRule => :16, ReleaseGenMethod => :17, MassUpdateReleases => :18, RetroactivePriceChange => :19, OrgAssignChange => :20, CommunicatePriceChange => :21, p_xml_flag => :22, FpdsngFlag => :23); END;
1g62m2w49xngu	BEGIN XNP_EVENT.PROCESS_IN_EVT(:1, :2, :3, :4) ; END;
1kjhvys1sd1sg	BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.OASubmitWorkflow(p_report_header_id => :1, p_preparer_id => :2, p_employee_id => :3, p_invoice_number => :4, p_reimb_curr => :5, p_cost_center => :6, p_purpose => :7, p_approver_id => :8, p_week_end_date => :9, p_workflow_appr_flag => :10, p_msg_count => :11);END;
1rd31t40r4fu5	BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
2714fpj38u2c0	SELECT HS.HOLD_SOURCE_ID, HS.HOLD_ID, HS.HOLD_ENTITY_CODE, HS.HOLD_ENTITY_ID, HS.HOLD_ENTITY_CODE2, HS.HOLD_ENTITY_ID2 FROM OE_HOLD_SOURCES HS, OE_HOLD_DEFINITIONS HLD WHERE HLD.HOLD_ID = HS.HOLD_ID AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >= ROUND( SYSDATE ) AND HS.RELEASED_FLAG = 'N' AND SYSDATE BETWEEN NVL( HLD.START_DATE_ACTIVE, SYSDATE ) AND NVL( HLD.END_DATE_ACTIVE, SYSDATE ) AND HS.HOLD_ENTITY_CODE = :B2 AND HS.HOLD_ENTITY_ID = :B1
2v1vanmps8nck	SELECT NVL(OT.CUST_TRX_TYPE_ID, 0) FROM OE_ORDER_TYPES_V OT, OE_ORDER_HEADERS_ALL OH WHERE OT.ORDER_TYPE_ID = OH.ORDER_TYPE_ID AND OH.HEADER_ID = :B1
327r1ynryuzvw	begin PO_REQAPPROVAL_ACTION.APPROVE_DOC (:v1, :v2, :v3, :v4, :v5); end;
34bx0h6k0q8a1	SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT, CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX, PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID, PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR, ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE (PR.CONDITION_GROUP_CODE = :B2 OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND EXISTS (SELECT /*+ no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE = RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE = PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a) use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX, RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM, -1 COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_RATE_CODE = :B4 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL) AND EXISTS (SELECT 1 FROM ZX_SCO_TAXES_B_V TAX WHERE TAX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y') ) ORDER BY COMPOUNDING_PRECEDENCE
3cv034rb4c2z4	SELECT RELATED_CUST_ACCOUNT_ID FROM HZ_CUST_ACCT_RELATE WHERE CUST_ACCOUNT_ID = :B1
3jznhhwdk3hj4	SELECT NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', NVL(ORDERED_QUANTITY, 0)*(UNIT_LIST_PRICE), 0)), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', 0, NVL(ORDERED_QUANTITY, 0)*(UNIT_LIST_PRICE))), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', NVL(ORDERED_QUANTITY, 0), 0)), 0), NVL(SUM(DECODE(LINE_CATEGORY_CODE, 'RETURN', 0, NVL(ORDERED_QUANTITY, 0))), 0) FROM OE_ORDER_LINES WHERE HEADER_ID=:B1 AND (CANCELLED_FLAG='N' OR CANCELLED_FLAG IS NULL) AND CHARGE_PERIODICITY_CODE IS NULL
3mbz7cvyf9cz3	BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3); END;
3mhu25sfw466x	begin :1 := POR_UTIL_PKG.submitreq(:2, :3, :4, :5, :6); end;
3vy5h9xkfv1s5	INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1
52uy1628x95hv	SELECT AD.TYPE TYPE, ADS.SEGMENT SEGMENT, UPPER(ADS.TABLE_NAME) TABLE_NAME, ADS.CONSTANT CONSTANT FROM RA_ACCOUNT_DEFAULT_SEGMENTS ADS, RA_ACCOUNT_DEFAULTS AD WHERE AD.GL_DEFAULT_ID = ADS.GL_DEFAULT_ID AND AD.ORG_ID = NVL(:B1 , AD.ORG_ID) AND AD.TYPE IN ( 'REV', 'REC', 'FREIGHT', 'TAX', 'UNBILL', 'UNEARN', 'SUSPENSE' ) ORDER BY TYPE, SEGMENT_NUM
54tzhmhcs8nkh	declare context DBMS_XMLGEN.ctxHandle; l_xml_query varchar2(15000) ; l_headerAttach_query varchar2(1000); l_lineAttach_query varchar2(1200) ; --Bug5213932 increase length l_disAttach_query varchar2(1200) ; --Bug5213932 increase length l_time varchar2(50); g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_COMMUNICATION_PVT.'; l_api_name CONSTANT VARCHAR2(30):= 'POXMLGEN'; TYPE ref_cursorType IS REF CURSOR; refcur ref_cursorType; l_fileClob CLOB := NULL; Begin l_xml_query := :1 ; l_headerAttach_query := :2; l_lineAttach_query := :3; l_disAttach_query := :4; l_fileClob := :5; select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Before Executing the Main Query', l_time); END IF; context := dbms_xmlgen.newContext(l_xml_query); dbms_xmlgen.setRowsetTag(context, 'PO_DATA'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xresult := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the Main Query', l_time); END IF; context := dbms_xmlgen.newContext(l_headerAttach_query); dbms_xmlgen.setRowsetTag(context, 'HEADER_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xheaderAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the header attachment Query', l_time); END IF; context := dbms_xmlgen.newContext(l_lineAttach_query); dbms_xmlgen.setRowsetTag(context, 'LINE_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xlineAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the line attachment Query', l_time); END IF; context := dbms_xmlgen.newContext(l_disAttach_query); dbms_xmlgen.setRowsetTag(context, 'SHIPMENT_ATTACHMENTS'); dbms_xmlgen.setRowTag(context, NULL); dbms_xmlgen.setConvertSpecialChars ( context, TRUE); :xdisAttach := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'After Executing the shipment attachment Query', l_time); END IF; IF l_fileClob is not null THEN open refcur for 'select :l_fileClob1 as text_file from dual' using l_fileClob; context := DBMS_XMLGEN.newContext(refcur); DBMS_XMLGEN.setRowTag(context, NULL); DBMS_XMLGEN.setRowSetTag(context, NULL); :xfileClob := DBMS_XMLGEN.getXML(context, DBMS_XMLGEN.NONE); DBMS_XMLGEN.closeContext(context); close refcur; IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'After executing the file clob'); END IF; ELSE IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name , 'Value of File clob is null'); END IF; :xfileClob := null; END IF; -- bug#3580225 Start -- select TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') into l_time from dual; IF (FND_LOG.G_CURRENT_RUNTIME_LEVE L <= FND_LOG.LEVEL_STATEMENT) THEN FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Before calling PO_HR_LOCATION.populate_gt', l_time); END IF; /* Call PO_HR_LOCATION.populate_gt procedure to insert address values into global temp table from PL/SQL table*/ PO_HR_LOCATION.populate_gt(); BEGIN context := dbms_xmlgen.newContext('select * from po_address_details_gt '); dbms_xmlgen.setRowsetTag(context, 'ADDRESS_DETAILS'); dbms_xmlgen.setRowTag(context, 'ADDRESS_DETAILS_ROW'); :xaddrDetails := dbms_xmlgen.getXML(context, DBMS_XMLGEN.NONE); dbms_xmlgen.closeContext(context); EXCEPTION WHEN OTHERS THEN NULL; END; -- bug#3580225 Start -- End;
586s962ytpygq	SELECT ORDERED_ITEM, ORDERED_QUANTITY, ORDER_QUANTITY_UOM, ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2, PREFERRED_GRADE, LINE_NUMBER, COMPONENT_NUMBER, REQUEST_DATE, SCHEDULE_SHIP_DATE, LINE_TYPE, CANCELLED_QUANTITY, CANCELLED_QUANTITY2, SHIPPED_QUANTITY, SHIPPED_QUANTITY2, PROMISE_DATE, PRICING_QUANTITY, PRICING_QUANTITY_UOM, SHIP_FROM, SOLD_TO, CUSTOMER_NUMBER, CUST_PO_NUMBER, CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER, DEMAND_BUCKET_TYPE_CODE, RLA_SCHEDULE_TYPE_CODE, CUSTOMER_DOCK_CODE, CUST_MODEL_SERIAL_NUMBER, CUSTOMER_PRODUCTION_LINE, CUST_PRODUCTION_SEQ_NUM, CUSTOMER_JOB, END_ITEM_UNIT_NUMBER, TAX_CODE, BLANKET_NUMBER, BLANKET_LINE_NUMBER, BLANKET_VERSION_NUMBER, PRICE_LIST, PRICING_DATE, SHIPMENT_NUMBER, TERMS, UNIT_LIST_PRICE, ORIGINAL_LIST_PRICE, ITEM_TYPE_CODE, OPTION_NUMBER, VISIBLE_DEMAND_FLAG, SCHEDULE_ARRIVAL_DATE, PLANNING_PRIORITY, ORIGINAL_ORDERED_ITEM, ORIGINAL_INVENTORY_ITEM_ID, ORIGINAL_ORDERED_ITEM_ID, item_relationship_type, LATE_DEMAND_PENALTY_FACTOR, ORIGINAL_ITEM_IDENTIFIER_TYPE, ITEM_SUBSTITUTION_TYPE_CODE, OVERRIDE_ATP_DATE_CODE, FIRM_DEMAND_FLAG, ITEM_IDENTIFIER_TYPE, UNIT_SELLING_PRICE, UNIT_COST, CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID, CALCULATE_PRICE_FLAG, TAX_EXEMPT_NUMBER, TAX_DATE, TAX_VALUE, TAX_POINT_CODE, ACCOUNTING_RULE, ACCOUNTING_RULE_DURATION, INVOICING_RULE, SUBINVENTORY, FULFILLED_QUANTITY, FULFILLED_QUANTITY2, INVOICED_QUANTITY, SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, USER_ITEM_DESCRIPTION, SHIP_FROM_LOCATION, SHIP_TO, SHIP_TO_LOCATION, SHIP_TO_CONTACT, SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4, SHIP_TO_ADDRESS5, SHIPPING_QUANTITY_UOM, SHIPPING_QUANTITY_UOM2, SHIPPING_QUANTITY, SHIPPING_QUANTITY2, DELIVERY_LEAD_TIME, INVOICE_TO, INVOICE_TO_LOCATION, INVOICE_TO_CONTACT, INVOICE_TO_ADDRESS1, INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4, INVOICE_TO_ADDRESS5, ITEM_REVISION, ROUNDING_FACTOR, SPLIT_BY, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, ORDER_NUMBER, VERSION_NUMBER, ORDER_TYPE, ORDERED_DATE, OVER_SHIP_REASON, first_ack_code, FIRST_ACK_DATE, last_ack_code, LAST_ACK_DATE, SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS, SERVICE_COTERMINATE_FLAG, SERVICE_DURATION, SERVICE_PERIOD, SERVICE_START_DATE, SERVICE_END_DATE, UNIT_SELLING_PERCENT, SERVICE_NUMBER, SERVICE_REFERENCE_TYPE_CODE, UNIT_LIST_PERCENT, UNIT_PERCENT_BASE_PRICE, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_CONTACT_ID, END_CUSTOMER_ID, IB_OWNER, IB_INSTALLED_AT_LOCATION, IB_CURRENT_LOCATION, REVREC_EXPIRATION_DAYS, ACCEPTED_QUANTITY, ACCEPTED_BY, REVREC_COMMENTS, REVREC_REFERENCE_DOCUMENT, REVREC_SIGNATURE, REVREC_SIGNATURE_DATE, REVREC_IMPLICIT_FLAG, CHARGE_PERIODICITY_CODE, EARLIEST_ACCEPTABLE_DATE, LATEST_ACCEPTABLE_DATE, ACTUAL_SHIPMENT_DATE, OVER_SHIP_RESOLVED_FLAG, ACTUAL_ARRIVAL_DATE, DEP_PLAN_REQUIRED_FLAG, AUTHORIZED_TO_SHIP_FLAG, COMMITMENT_ID, LOCK_CONTROL, ORDER_SOURCE_ID, TAX_EXEMPT_REASON_CODE, FULFILLED_FLAG, FULFILLMENT_METHOD_CODE, TAX_EXEMPT_FLAG, CONTINGENCY_ID, REVREC_EVENT_CODE, TAX_RATE, FREIGHT_TERMS_CODE, SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE, FOB_POINT_CODE, INVOICE_INTERFACE_STATUS_CODE, SHIP_MODEL_COMPLETE_FLAG, SOURCE_DOCUMENT_TYPE_ID, SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID, ROW_ID, HEADER_ROW_ID, REFERENCE_HEADER_ID, REFERENCE_LINE_ID, REFERENCE_CUSTOMER_TRX_LINE_ID, CREDIT_INVOICE_LINE_ID, LINE_ID, ORG_ID, HEADER_ID, LINE_TYPE_ID, LINE_SET_ID, CONFIG_HEADER_ID, CONFIG_REV_NBR, SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, SOLD_FROM_ORG_ID, SHIP_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID, INTMED_SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID, INVENTORY_ITEM_ID, SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID, PRICE_LIST_ID, AGREEMENT_ID, PAYMENT_TERM_ID, INVOICING_RULE_ID, ACCOUNTING_RULE_ID, SPLIT_FROM_LINE_ID, VEH_CUS_ITEM_CUM_KEY_ID, SALESREP_ID, RETURN_REASON_CODE, ARRIVAL_SET_ID, SHIP_SET_ID, ORDERED_ITEM_ID, OVER_SHIP_REASON_CODE, CONTEXT, SCHEDULE_STATUS_CODE, FLOW_STATUS_CO DE, SOURCE_TYPE_CODE, DEMAND_CLASS_CODE, TRANSACTION_PHASE_CODE, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, INDUSTRY_CONTEXT, INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTRIBUTE4, INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE14, INDUSTRY_ATTRIBUTE15, INDUSTRY_ATTRIBUTE16, INDUSTRY_ATTRIBUTE17, INDUSTRY_ATTRIBUTE18, INDUSTRY_ATTRIBUTE19, INDUSTRY_ATTRIBUTE20, INDUSTRY_ATTRIBUTE21, INDUSTRY_ATTRIBUTE22, INDUSTRY_ATTRIBUTE23, INDUSTRY_ATTRIBUTE24, INDUSTRY_ATTRIBUTE25, INDUSTRY_ATTRIBUTE26, INDUSTRY_ATTRIBUTE27, INDUSTRY_ATTRIBUTE28, INDUSTRY_ATTRIBUTE29, INDUSTRY_ATTRIBUTE30, RETURN_CONTEXT, RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15, TP_CONTEXT, TP_ATTRIBUTE1, TP_ATTRIBUTE2, TP_ATTRIBUTE3, TP_ATTRIBUTE4, TP_ATTRIBUTE5, TP_ATTRIBUTE6, TP_ATTRIBUTE7, TP_ATTRIBUTE8, TP_ATTRIBUTE9, TP_ATTRIBUTE10, TP_ATTRIBUTE11, TP_ATTRIBUTE12, TP_ATTRIBUTE13, TP_ATTRIBUTE14, TP_ATTRIBUTE15, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID, COMPONENT_SEQUENCE_ID, CONFIGURATION_ID, TOP_MODEL_LINE_ID, LINK_TO_LINE_ID, CONFIG_DISPLAY_SEQUENCE, COMPONENT_CODE, SORT_ORDER, SOLD_TO_ORG_ID, FREIGHT_CARRIER_CODE, PROJECT_ID, TASK_ID, LINE_CATEGORY_CODE, MODEL_REMNANT_FLAG, CUSTOMER_TRX_LINE_ID, OPTION_FLAG, BOOKED_FLAG, OPEN_FLAG, CANCELLED_FLAG, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, SHIPPING_INTERFACED_FLAG, ATO_LINE_ID, AUTO_SELECTED_QUANTITY, EXPLOSION_DATE, MODEL_GROUP_NUMBER FROM OE_ORDER_LINES_V WHERE (HEADER_ID=:1) order by line_number, shipment_number, nvl(option_number, -:"SYS_B_0"), nvl(component_number, -:"SYS_B_1"), nvl(service_number, -:"SYS_B_2")
5j000r4cc1kaz	SELECT PERIOD3_ORDERED_QUANTITY, PRIMARY_UOM_CODE FROM OE_ITEM_CUST_VOLS WHERE SOLD_TO_ORG_ID = :B2 AND INVENTORY_ITEM_ID = :B1
6129566gyvx21	SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_types WHERE type_name = :1 AND owner = :2
66tmsr3446uqn	SELECT WIAS.ACTIVITY_STATUS, WIAS.ACTIVITY_RESULT_CODE, WIAS.ASSIGNED_USER, WIAS.NOTIFICATION_ID, WIAS.BEGIN_DATE, WIAS.END_DATE, WIAS.DUE_DATE, WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE, WIAS.ERROR_STACK FROM WF_ITEM_ACTIVITY_STATUSES WIAS WHERE WIAS.ITEM_TYPE = :B3 AND WIAS.ITEM_KEY = :B2 AND WIAS.PROCESS_ACTIVITY = :B1
67mmmbx5hb3p0	BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;
6qw73fgxy7x1f	SELECT 1 FROM ASG_USER AU, CS_INCIDENTS_ALL_B CSA WHERE CSA.INCIDENT_ID = :B1 AND (CSA.OWNER_GROUP_ID = AU.GROUP_ID AND AU.USER_ID=AU.OWNER_ID) OR AU.USER_ID=CSA.CREATED_BY OR EXISTS(SELECT 1 FROM JTF_TASK_ASSIGNMENTS JTA, JTF_TASKS_B JT WHERE JT.SOURCE_OBJECT_ID = CSA.INCIDENT_ID AND JT.SOURCE_OBJECT_TYPE_CODE = 'SR' AND JTA.TASK_ID = JT.TASK_ID AND AU.RESOURCE_ID = JTA.RESOURCE_ID) OR EXISTS(SELECT 1 FROM JTF_TASKS_B JT WHERE JT.SOURCE_OBJECT_ID = CSA.INCIDENT_ID AND JT.SOURCE_OBJECT_TYPE_CODE = 'SR' AND JT.CREATED_BY=AU.USER_ID)
6vx0fw5141z4n	SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 )
6y2m7nrx0s6tn	BEGIN DECLARE l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ; BEGIN l_msg_header.message_id := :message_id ; l_msg_header.message_code := :message_code ; l_msg_header.reference_id := :reference_id ; l_msg_header.opp_reference_id := :opp_ref_id ; l_msg_header.creation_date := :creation_date; l_msg_header.sender_name := :sender_name ; l_msg_header.recipient_name := :recipient_name ; l_msg_header.version := :version; l_msg_header.direction_indr := :direction_indr ; l_msg_header.order_id := :order_id ; l_msg_header.wi_instance_id := :wi_instance_id ; l_msg_header.fa_instance_id := :fa_instance_id ; XNP_CSISUBTR_U.DEFAULT_PROCESS( l_msg_header, :l_msg_body, :error_code, :error_message ) ; END ; END ;
7ujfmgb1j83a3	BEGIN FND_AOLJ_UTIL.SET_NLS_CONTEXT( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13);END;
85gad38y8bvv3	begin :1 :=PO_COMMUNICATION_PVT.POXMLGEN( :2, :3, :4, :5, :6, :7, :8, :9); end;
87ddc500f4yst	SELECT "A3"."SHIPMENT_NUM" "SHIPMENT_NUM", "A3"."DUE_DATE" "DUE_DATE", "A3"."QUANTITY" "QUANTITY", "A3"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A3"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A3"."CANCEL_FLAG" "CANCEL_FLAG", "A3"."CANCEL_DATE" "CANCEL_DATE", "A3"."CANCEL_REASON" "CANCEL_REASON", "A3"."TAXABLE_FLAG" "TAXABLE_FLAG", "A3"."START_DATE" "START_DATE", "A3"."END_DATE" "END_DATE", "A3"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A3"."ATTRIBUTE1" "ATTRIBUTE1", "A3"."ATTRIBUTE2" "ATTRIBUTE2", "A3"."ATTRIBUTE3" "ATTRIBUTE3", "A3"."ATTRIBUTE4" "ATTRIBUTE4", "A3"."ATTRIBUTE5" "ATTRIBUTE5", "A3"."ATTRIBUTE6" "ATTRIBUTE6", "A3"."ATTRIBUTE7" "ATTRIBUTE7", "A3"."ATTRIBUTE8" "ATTRIBUTE8", "A3"."ATTRIBUTE9" "ATTRIBUTE9", "A3"."ATTRIBUTE10" "ATTRIBUTE10", "A3"."ATTRIBUTE11" "ATTRIBUTE11", "A3"."ATTRIBUTE12" "ATTRIBUTE12", "A3"."ATTRIBUTE13" "ATTRIBUTE13", "A3"."ATTRIBUTE14" "ATTRIBUTE14", "A3"."ATTRIBUTE15" "ATTRIBUTE15", "A3"."PO_HEADER_ID" "PO_HEADER_ID", "A3"."PO_LINE_ID" "PO_LINE_ID", "A3"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A3"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A3"."PO_RELEASE_ID" "PO_RELEASE_ID", "A3"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A3"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A3"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A3"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A3"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A3"."CLOSED_REASON" "CLOSED_REASON", "A3"."CLOSED_DATE" "CLOSED_DATE", "A3"."CLOSED_BY" "CLOSED_BY", "A3"."ORG_ID" "ORG_ID", "A3"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A3"."ENCUMBER_NOW" "ENCUMBER_NOW", "A3"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A3"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A3"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A3"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A3"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A3"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A3"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A3"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A3"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A3"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A3"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A3"."SHIP_TO_ORGANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A3"."SOURCE_SHIPMENT_ID " "SOURCE_SHIPMENT_ID", "A3"."CLOSED_CODE" "CLOSED_CODE", "A3"."REQUEST_ID" "REQUEST_ID", "A3"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A3"."PROGRAM_ID" "PROGRAM_ID", "A3"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A3"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A3"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A3"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A3"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A3"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A3"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A3"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A3"."FROM_HEADER_ID" "FROM_HEADER_ID", "A3"."FROM_LINE_ID" "FROM_LINE_ID", "A3"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A3"."LEAD_TIME" "LEAD_TIME", "A3"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A3"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A3"."TERMS_ID" "TERMS_ID", "A3"."APPROVED_FLAG" "APPROVED_FLAG", "A3"."APPROVED_DATE" "APPROVED_DATE", "A3"."CLOSED_FLAG" "CLOSED_FLAG", "A3"."CANCELLED_BY" "CANCELLED_BY", "A3"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A3"."FIRM_DATE" "FIRM_DATE", "A3"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A3"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A3"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A3"."CREATION_DATE" "CREATION_DATE", "A3"."CREATED_BY" "CREATED_BY", "A3"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A3"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A3"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A3"."QUANTITY_BILLED" "QUANTITY_BILLED", "A3"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A3"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A3"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A3"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A3"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A3"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A3"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A3"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A3"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A3"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A3"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A3"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A3"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A3"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A3"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A3"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A3"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A3"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A3"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A3"."GLOBAL _ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A3"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A3"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A3"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A3"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A3"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A3"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A3"."MATCH_OPTION" "MATCH_OPTION", "A3"."TAX_CODE_ID" "TAX_CODE_ID", "A3"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A3"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A3"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A3"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A3"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A3"."PREFERRED_GRADE" "PREFERRED_GRADE", "A3"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A3"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A3"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A3"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A3"."VMI_FLAG" "VMI_FLAG", "A3"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A3"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A3"."AMOUNT" "AMOUNT", "A3"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A3"."AMOUNT_BILLED" "AMOUNT_BILLED", "A3"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A3"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A3"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A3"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A3"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A3"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A3"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A3"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A3"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A3"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A3"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A3"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A3"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A3"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A3"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A3"."DETAILS" "DETAILS", "A3"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A3"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A3"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A3"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A3"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A3"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A3"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A3"."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A3"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A3"."ULTIMATE_DELIV ER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A3"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A3"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A3"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A3"."SHIPPING_METHOD" "SHIPPING_METHOD", "A3"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A3"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A3"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A3"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A3"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A3"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A3"."NEED_BY_DATE" "NEED_BY_DATE", "A3"."PROMISED_DATE" "PROMISED_DATE", "A3"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A3"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A3"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A3"."TAX_NAME" "TAX_NAME", "A3"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A3"."VALUE_BASIS" "VALUE_BASIS", "A3"."MATCHING_BASIS" "MATCHING_BASIS", "A3"."PAYMENT_TYPE" "PAYMENT_TYPE", "A3"."DESCRIPTION" "DESCRIPTION", "A3"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A3"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A3"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A3"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A3"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A3"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A3"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A3"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A3"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A3"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A61"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A62", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A61" WHERE "A62"."ENTITY_NAME"='PO_SHIPMENTS' AND "A62"."PK1_VALUE"=TO_CHAR("A3"."LINE_LOCATION_ID") AND "A62"."FUNCTION_NAME"='PO_PRINTPO' AND "A62"."MEDIA_ID"="A61"."MEDIA_ID" AND "A62"."DATATYPE_ID"=1 ORDER BY "A62"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A60"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A60" WHERE "A60"."ENTITY_NAME"='PO_SHIPMENTS' AND "A60"."PK1_VALUE"=TO_CHAR("A3"."LINE_LOCATION_ID") AND "A60"."DATATYPE_ID"=5 AND "A60"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A60"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A59"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A59" WHERE "A59"."ENTITY_NAME"='PO_SHIPMENTS' AND "A59"."PK1_VALUE"=TO_CHAR("A3"."LINE_LOCATION_ID") AND "A59"."DATATYPE_ID"=6 AND "A59"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A59". "SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A58"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A58"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A58"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A58"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A58"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A58"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A58"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A58"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A58"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A58"."PROJECT_ID" "PROJECT_ID", "A58"."TASK_ID" "TASK_ID", "A58"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A58"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A58"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A58"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A58"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A58"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A58"."ORG_ID" "ORG_ID", "A58"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A58"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A58"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A58"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A58"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A58"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A58"."ATTRIBUTE1" "ATTRIBUTE1", "A58"."ATTRIBUTE2" "ATTRIBUTE2", "A58"."ATTRIBUTE3" "ATTRIBUTE3", "A58"."ATTRIBUTE4" "ATTRIBUTE4", "A58"."ATTRIBUTE5" "ATTRIBUTE5", "A58"."ATTRIBUTE6" "ATTRIBUTE6", "A58"."ATTRIBUTE7" "ATTRIBUTE7", "A58"."ATTRIBUTE8" "ATTRIBUTE8", "A58"."ATTRIBUTE9" "ATTRIBUTE9", "A58"."ATTRIBUTE10" "ATTRIBUTE10", "A58"."ATTRIBUTE11" "ATTRIBUTE11", "A58"."ATTRIBUTE12" "ATTRIBUTE12", "A58"."ATTRIBUTE13" "ATTRIBUTE13", "A58"."ATTRIBUTE14" "ATTRIBUTE14", "A58"."ATTRIBUTE15" "ATTRIBUTE15", "A58"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A58"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A58"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A58"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A58"."WIP_LINE_ID" "WIP_LINE_ID", "A58"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A58"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A58"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A58"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A58"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", "A58"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A58"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A58"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID ", "A58"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A58"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A58"."PO_HEADER_ID" "PO_HEADER_ID", "A58"."PO_LINE_ID" "PO_LINE_ID", "A58"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A58"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A58"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A58"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A58"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A58"."CREATION_DATE" "CREATION_DATE", "A58"."CREATED_BY" "CREATED_BY", "A58"."PO_RELEASE_ID" "PO_RELEASE_ID", "A58"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A58"."QUANTITY_BILLED" "QUANTITY_BILLED", "A58"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A58"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A58"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A58"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A58"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A58"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A58"."RATE_DATE" "RATE_DATE", "A58"."RATE" "RATE", "A58"."AMOUNT_BILLED" "AMOUNT_BILLED", "A58"."ACCRUED_FLAG" "ACCRUED_FLAG", "A58"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A58"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A58"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A58"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A58"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A58"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A58"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A58"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A58"."AWARD_ID" "AWARD_ID", "A58"."MRC_RATE_DATE" "MRC_RATE_DATE", "A58"."MRC_RATE" "MRC_RATE", "A58"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A58"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A58"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A58"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A58"."RECOVERY_RATE" "RECOVERY_RATE", "A58"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A58"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A58"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A58"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A58"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A58"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A58"."REQUEST_ID" "REQUEST_ID", "A58"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A58"."PROGRAM_ID" "PROGRAM_ID", "A58"."CHARGE_ACCOUNT" "CHARGE_ACCOUNT", "A58"."FULL_NAME" "FULL_NAME", "A58"."WORK_TELEPHONE" "WORK_TELEPHONE", "A58"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A58"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A58"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A58"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A58"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A58"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A58"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A58"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A58"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A58"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A58" WHERE "A58"."PO_HEADER_ID"=:CV1$$ AND "A58"."LINE_LOCATION_ID"="A3"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A3" WHERE "A3"."PO_LINE_ID"=:CV1$ AND NVL("A3"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A3"."PAYMENT_TYPE", 'NONE')<>'DELIVERY' AND NOT EXISTS (SELECT 0 FROM "PO"."PO_LINE_LOCATIONS_ARCHIVE_ALL" "A57" WHERE "A57"."LINE_LOCATION_ID"="A3"."LINE_LOCATION_ID" AND "A57"."CANCEL_FLAG"='Y' AND "A57"."REVISION_NUM"<"APPS"."PO_COMMUNICATION_PVT"."GETREVISIONNUM"()) ORDER BY "A3"."SHIPMENT_NUM"
8m3upvff5g0ds	begin :v1 := WF_RULE.default_rule(:v2, :v3); end;
91hakq9n36htp	SELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
aa6zd9qzswmpt	SELECT NVL(GSA_INDICATOR, 'N') FROM HZ_CUST_SITE_USES HSU WHERE SITE_USE_ID = :B2 AND HSU.ORG_ID = :B1
agtxztg8fs5qd	begin :v1 := ADS_ITIL_DEMO_PKG.Custom_Rule(:v2, :v3); end;
akma8kaxsp84b	SELECT reservation_id , requirement_date , organization_id , inventory_item_id , demand_source_type_id , demand_source_name , demand_source_header_id , demand_source_line_id , demand_source_delivery , primary_uom_code , primary_uom_id , secondary_uom_code , secondary_uom_id , reservation_uom_code , reservation_uom_id , reservation_quantity , primary_reservation_quantity , secondary_reservation_quantity , detailed_quantity , secondary_detailed_quantity , autodetail_group_id , external_source_code , external_source_line_id , supply_source_type_id , supply_source_header_id , supply_source_line_id , supply_source_name , supply_source_line_detail , revision , subinventory_code , subinventory_id , locator_id , lot_number , lot_number_id , pick_slip_number , lpn_id , attribute_category , attribute1 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 , attribute7 , attribute8 , attribute9 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14 , attribute15 , ship_ready_flag , staged_flag /**** {{ R12 Enhanced reservations code changes }}****/ , crossdock_flag , crossdock_criteria_id , demand_source_line_detail , serial_reservation_quantity , supply_receipt_date , demand_ship_date , project_id , task_id , orig_supply_source_type_id , orig_supply_source_header_id , orig_supply_source_line_id , orig_supply_source_line_detail , orig_demand_source_type_id , orig_demand_source_header_id , orig_demand_source_line_id , orig_demand_source_line_detail , serial_number /***** End R12 ***/ FROM mtl_reservations WHERE (:requirement_date = :l_miss_date OR :requirement_date IS NULL AND requirement_date IS NULL OR :requirement_date = requirement_date ) AND (:organization_id = :l_miss_num OR :organization_id IS NULL AND organization_id IS NULL OR :organization_id = organization_id ) AND (:inventory_item_id = :l_miss_num OR :inventory_item_id IS NULL AND inventory_item_id IS NULL OR :inventory_item_id = inventory_item_id ) AND (:demand_source_type_id = :l_miss_num OR :demand_source_type_id IS NULL AND demand_source_type_id IS NULL OR :demand_source_type_id = demand_source_type_id ) AND (:demand_source_header_id = :l_miss_num OR :demand_source_header_id IS NULL AND demand_source_header_id IS NULL OR :demand_source_header_id = demand_source_header_id ) AND (:demand_source_line_id = :l_miss_num OR :demand_source_line_id IS NULL AND demand_source_line_id IS NULL OR :demand_source_line_id = demand_source_line_id ) AND (:demand_source_name = :l_miss_char OR :demand_source_name IS NULL AND demand_source_name IS NULL OR :demand_source_name = demand_source_name ) AND (:demand_source_delivery = :l_miss_num OR :demand_source_delivery IS NULL AND demand_source_delivery IS NULL OR :demand_source_delivery = demand_source_delivery ) AND (:primary_uom_code = :l_miss_char OR :primary_uom_code IS NULL AND primary_uom_code IS NULL OR :primary_uom_code = primary_uom_code ) AND (:primary_uom_id = :l_miss_num OR :primary_uom_id IS NULL AND primary_uom_id IS NULL OR :primary_uom_id = primary_uom_id ) -- INVCONV BEGIN AND (:secondary_uom_code = :l_miss_char OR :secondary_uom_code IS NULL AND secondary_uom_code IS NULL OR :secondary_uom_code = secondary_uom_code ) AND (:secondary_uom_id = :l_miss_num OR :secondary_uom_id IS NULL AND secondary_uom_id IS NULL OR :secondary_uom_id = secondary_uom_id ) -- INVCONV END AND (:reservation_uom_code = :l_miss_char OR :reservation_uom_code IS NULL AND reservation_uom_code IS NULL OR :reservation_uom_code = reservation_uom_code ) AND (:reservation_uom_id = :l_miss_num OR :reservation_uom_id IS NULL AND reservation_uom_id IS NULL OR :reservation_uom_id = reservation_uom_id ) AND (:autodetail_group_id = :l_miss_num OR :autodetail_group_id IS NULL AND autodetail_group_id IS NULL OR :autodetail_group_id = autodetail_group_id ) AND (:external_source_code = :l_miss_char OR :external_source_code IS NULL AND external_source_code IS NULL OR :external_s ource_code = external_source_code ) AND (:external_source_line_id = :l_miss_num OR :external_source_line_id IS NULL AND external_source_line_id IS NULL OR :external_source_line_id = external_source_line_id ) AND (:supply_source_type_id = :l_miss_num OR :supply_source_type_id IS NULL AND supply_source_type_id IS NULL OR :supply_source_type_id = supply_source_type_id ) AND (:supply_source_header_id = :l_miss_num OR :supply_source_header_id IS NULL AND supply_source_header_id IS NULL OR :supply_source_header_id = supply_source_header_id ) AND (:supply_source_line_id = :l_miss_num OR :supply_source_line_id IS NULL AND supply_source_line_id IS NULL OR :supply_source_line_id = supply_source_line_id ) AND (:supply_source_name = :l_miss_char OR :supply_source_name IS NULL AND supply_source_name IS NULL OR :supply_source_name = supply_source_name ) AND (:supply_source_line_detail = :l_miss_num OR :supply_source_line_detail IS NULL AND supply_source_line_detail IS NULL OR :supply_source_line_detail = supply_source_line_detail ) AND (:revision = :l_miss_char OR :revision IS NULL AND revision IS NULL OR :revision = revision ) AND (:subinventory_code = :l_miss_char OR :subinventory_code IS NULL AND subinventory_code IS NULL OR :subinventory_code = subinventory_code ) AND (:subinventory_id = :l_miss_num OR :subinventory_id IS NULL AND subinventory_id IS NULL OR :subinventory_id = subinventory_id ) AND (:locator_id = :l_miss_num OR :locator_id IS NULL AND locator_id IS NULL OR :locator_id = locator_id ) AND (:lot_number = :l_miss_char OR :lot_number IS NULL AND lot_number IS NULL OR :lot_number = lot_number ) AND (:lot_number_id = :l_miss_num OR :lot_number_id IS NULL AND lot_number_id IS NULL OR :lot_number_id = lot_number_id ) AND (:lpn_id = :l_miss_num OR :lpn_id IS NULL AND lpn_id IS NULL OR :lpn_id = lpn_id ) AND (:ship_ready_flag = :l_miss_num OR (:ship_ready_flag IS NULL OR :ship_ready_flag = 2) AND (ship_ready_flag IS NULL OR ship_ready_flag = 2) OR :ship_ready_flag = ship_ready_flag ) AND (:staged_flag = :l_miss_char OR (:staged_flag IS NULL OR :staged_flag = 'N') AND (staged_flag IS NULL OR staged_flag = 'N') OR :staged_flag = staged_flag ) AND (:attribute_category = :l_miss_char OR :attribute_category IS NULL AND attribute_category IS NULL OR :attribute_category = attribute_category ) AND (:attribute1 = :l_miss_char OR :attribute1 IS NULL AND attribute1 IS NULL OR :attribute1 = attribute1 ) AND (:attribute2 = :l_miss_char OR :attribute2 IS NULL AND attribute2 IS NULL OR :attribute2 = attribute2 ) AND (:attribute3 = :l_miss_char OR :attribute3 IS NULL AND attribute3 IS NULL OR :attribute3 = attribute3 ) AND (:attribute4 = :l_miss_char OR :attribute4 IS NULL AND attribute4 IS NULL OR :attribute4 = attribute4 ) AND (:attribute5 = :l_miss_char OR :attribute5 IS NULL AND attribute5 IS NULL OR :attribute5 = attribute5 ) AND (:attribute6 = :l_miss_char OR :attribute6 IS NULL AND attribute6 IS NULL OR :attribute6 = attribute6 ) AND (:attribute7 = :l_miss_char OR :attribute7 IS NULL AND attribute7 IS NULL OR :attribute7 = attribute7 ) AND (:attribute8 = :l_miss_char OR :attribute8 IS NULL AND attribute8 IS NULL OR :attribute8 = attribute8 ) AND (:attribute9 = :l_miss_char OR :attribute9 IS NULL AND attribute9 IS NULL OR :attribute9 = attribute9 ) AND (:attribute10 = :l_miss_char OR :attribute10 IS NULL AND attribute10 IS NULL OR :attribute10 = attribute10 ) AND (:attribute11 = :l_miss_char OR :attribute11 IS NULL AND attribute11 IS NULL OR :attribute11 = attribute11 ) AND (:attribute12 = :l_miss_char OR :attribute12 IS NULL AND attribute12 IS NULL OR :attribute12 = attribute12 ) AND (:attribute13 = :l_miss_char OR :attribute13 IS NULL AND attribute13 IS NULL OR :attribute13 = attribute13 ) AND (:attribute14 = :l_miss_char OR :attribute14 IS NULL AND attribute14 IS NULL OR :attribute14 = attribute14 ) AND (:attribute15 = :l_miss_char OR :attribute15 IS NULL AND attribute15 IS NULL OR :attribute15 = attribute15 ) /**** {{ R12 Enhanced reserv ations code changes }}****/ AND (:crossdock_flag = :l_miss_char OR :crossdock_flag IS NULL AND crossdock_flag IS NULL OR :crossdock_flag = crossdock_flag ) AND (:crossdock_criteria_id = :l_miss_num OR :crossdock_criteria_id IS NULL AND crossdock_criteria_id IS NULL OR :crossdock_criteria_id = crossdock_criteria_id ) AND (:demand_source_line_detail = :l_miss_num OR :demand_source_line_detail IS NULL AND demand_source_line_detail IS NULL OR :demand_source_line_detail = demand_source_line_detail ) AND (:supply_receipt_date = :l_miss_date OR :supply_receipt_date IS NULL AND supply_receipt_date IS NULL OR :supply_receipt_date = supply_receipt_date ) AND (:demand_ship_date = :l_miss_date OR :demand_ship_date IS NULL AND demand_ship_date IS NULL OR :demand_ship_date = demand_ship_date ) AND (:project_id = :l_miss_num OR :project_id IS NULL AND project_id IS NULL OR :project_id = project_id ) AND (:task_id = :l_miss_num OR :task_id IS NULL AND task_id IS NULL OR :task_id = task_id ) /***** End R12 ***/ ORDER BY NVL(DEMAND_SHIP_DATE, REQUIREMENT_DATE) ASC
bbugagurwv1vy	(SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE OPTION_NAME = UPPER(:B1 ))
bdmz25gp0v0nb	SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID FROM RA_CUSTOMER_TRX_LINES WHERE interface_line_context = 'LEGACY' AND customer_trx_line_id+0 <> NVL(:customer_trx_line_id, -98) AND INTERFACE_LINE_ATTRIBUTE1 = :INTERFACE_LINE_ATTRIBUTE1 AND INTERFACE_LINE_ATTRIBUTE2 = :INTERFACE_LINE_ATTRIBUTE2
ccprbqfuu8wb1	SELECT NUMBER_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
cd9mbmqyf4qhp	UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1
ck33dx7qyft46	SELECT phx.*, PO_COMMUNICATION_PVT.getIsComplexWorkPO() is_complex_work_po, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message, PO_COMMUNICATION_PVT.getTimezone() timezone, PO_COMMUNICATION_PVT.getAmendmentMessage() ammendment_message, PO_COMMUNICATION_PVT.getTestFlag() test_flag, PO_COMMUNICATION_PVT.getDistinctShipmentCount() DIST_SHIPMENT_COUNT, PO_COMMUNICATION_PVT.getDocumentName() document_name, PO_COMMUNICATION_PVT.IsDocumentSigned(PO_COMMUNICATION_PVT.getDocumentId()) Signed, fnd_profile.value(:"SYS_B_000") amendment_profile, PO_COMMUNICATION_PVT.getWithTerms() With_Terms , PO_COMMUNICATION_PVT.getIsContractAttachedDoc() Is_Attached_Doc , CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in ( :"SYS_B_001", :"SYS_B_002", :"SYS_B_003", :"SYS_B_004", :"SYS_B_005", :"SYS_B_006", :"SYS_B_007", :"SYS_B_008", :"SYS_B_009", :"SYS_B_010", :"SYS_B_011", :"SYS_B_012", :"SYS_B_013", :"SYS_B_014", :"SYS_B_015", :"SYS_B_016", :"SYS_B_017", :"SYS_B_018", :"SYS_B_019", :"SYS_B_020", -- <Complex Work R12> :"SYS_B_021", :"SYS_B_022", :"SYS_B_023", :"SYS_B_024", :"SYS_B_025", :"SYS_B_026", :"SYS_B_027", :"SYS_B_028", :"SYS_B_029", :"SYS_B_030", :"SYS_B_031", :"SYS_B_032", :"SYS_B_033", :"SYS_B_034", :"SYS_B_035", :"SYS_B_036", :"SYS_B_037", :"SYS_B_038", :"SYS_B_039", :"SYS_B_040", :"SYS_B_041", -- <Complex Work R12> :"SYS_B_042", -- <Complex Work R12> :"SYS_B_043", -- <Complex Work R12> :"SYS_B_044", -- <Complex Work R12> :"SYS_B_045", -- <Complex Work R12> :"SYS_B_046", :"SYS_B_047", :"SYS_B_048", :"SYS_B_049", :"SYS_B_050", :"SYS_B_051", :"SYS_B_052", :"SYS_B_053", :"SYS_B_054", :"SYS_B_055", :"SYS_B_056", :"SYS_B_057", :"SYS_B_058", :"SYS_B_059", :"SYS_B_060", :"SYS_B_061", :"SYS_B_062", :"SYS_B_063", :"SYS_B_064", :"SYS_B_065", :"SYS_B_066", :"SYS_B_067", :"SYS_B_068", :"SYS_B_069", :"SYS_B_070", :"SYS_B_071", :"SYS_B_072", :"SYS_B_073", :"SYS_B_074", :"SYS_B_075", :"SYS_B_076", :"SYS_B_077", :"SYS_B_078", :"SYS_B_079", :"SYS_B_080", :"SYS_B_081", :"SYS_B_082", :"SYS_B_083", :"SYS_B_084", :"SYS_B_085", :"SYS_B_086", :"SYS_B_087", :"SYS_B_088", :"SYS_B_089", :"SYS_B_090", :"SYS_B_091", :"SYS_B_092", :"SYS_B_093", :"SYS_B_094", :"SYS_B_095", :"SYS_B_096", :"SYS_B_097", :"SYS_B_098", :"SYS_B_099", :"SYS_B_100", :"SYS_B_101", :"SYS_B_102", :"SYS_B_103", :"SYS_B_104", :"SYS_B_105", :"SYS_B_106", :"SYS_B_107", :"SYS_B_108", :"SYS_B_109", :"SYS_B_110", :"SYS_B_111", :"SYS_B_112", :"SYS_B_113", --<Bug#: 4899200> :"SYS_B_114", --<Bug#: 4899200> :"SYS_B_115", --<Bug#: 4899200> :"SYS_B_116", --<Bug#: 5464968> : "SYS_B_117", --Enhanced Pricing :"SYS_B_118", --Enhanced Pricing :"SYS_B_119", --Enhanced Pricing :"SYS_B_120", --Enhanced Pricing :"SYS_B_121", --Enhanced Pricing :"SYS_B_122", --Enhanced Pricing :"SYS_B_123", --Enhanced Pricing :"SYS_B_124", --Enhanced Pricing :"SYS_B_125" --<Bug#: 5464968> ) AND application_id = :"SYS_B_126" AND language_code = :"SYS_B_127") AS message, CURSOR( SELECT fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((entity_name = :"SYS_B_128" AND pk1_value = to_char(phx.po_header_id)) OR (entity_name = :"SYS_B_129" AND pk1_value = to_char(phx.vendor_id)) OR (entity_name = :"SYS_B_130" AND pk1_value = to_char(phx.vendor_site_id))) AND -- bug6154354 function_name = :"SYS_B_131" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_132" order by fad.seq_num) AS header_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name=:"SYS_B_133" AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name=:"SYS_B_134" AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name=:"SYS_B_135" AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=:"SYS_B_136" AND fad.function_name=:"SYS_B_137" order by fad.entity_name, fad.seq_num) AS header_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name=:"SYS_B_138" AND fad.pk1_value=to_char(phx.po_header_id)) OR (fad.entity_name=:"SYS_B_139" AND fad.pk1_value=to_char(phx.vendor_id)) OR (fad.entity_name=:"SYS_B_140" AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354 ) AND fad.datatype_id=:"SYS_B_141" AND fad.function_name=:"SYS_B_142" order by fad.entity_name, fad.seq_num) AS header_file_attachments, CURSOR(SELECT plx.*, CURSOR(SELECT PRICE_TYPE_DSP PRICE_TYPE, MULTIPLIER FROM po_price_differentials_v WHERE entity_type=:"SYS_B_143" AND entity_id = plx.po_line_id and enabled_flag=:"SYS_B_144") AS price_diff, CURSOR( SELECT plx.po_line_id , fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE ((fad.entity_name=:"SYS_B_145" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"SYS_B_146" AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND --Bug6139548 fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) OR (fad.entity_name=:"SYS_B_147" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_148" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_149" AND fad.pk1_value=to_char(plx.CONTRACT_ID) AND plx.CONTRACT_ID IS NOT NULL) ) AND function_name = :"SYS_B_150" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_151" order by fad.seq_num) AS line_short_text, CURSOR (SELECT pax1.* FROM PO_PRICE_ADJUSTMENTS_XML pax1 WHERE pax1.po_header_id = plx.po_header_id AND pax1.po_line_id = plx.po_line_id AND pax1.parent_adjustment_id is null order by pax1.pricing_group_sequence) AS PRICE_MODIFIERS, CURSOR (SELECT pax2.* FROM PO_PRICE_ADJUSTMENTS_XML pax2 WHERE pax2.po_header_id = plx.from_header_id AND pax2.po_line_id = plx.from_line_id AND pax2.parent_adjustment_id is null order by pax2.pricing_group_sequence) AS ADD_PRICE_MODIFIERS, CURSOR (SELECT pha.segment1 ponum FROM po_headers_all pha WHERE pha.po_header_id = plx.from_header_id) AS ADD_PRICE_PONUM, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name=:"SYS_B_152" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"S YS_B_153" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_154" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_155" AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_156" AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=:"SYS_B_157" AND fad.function_name=:"SYS_B_158" order by fad.seq_num) AS line_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE ((fad.entity_name=:"SYS_B_159" AND fad.pk1_value=to_char(plx.po_line_id)) OR (fad.entity_name=:"SYS_B_160" AND fad.pk1_value=to_char(plx.from_header_id) AND plx.from_header_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_161" AND fad.pk1_value=to_char(plx.from_line_id) AND plx.from_line_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_162" AND fad.pk1_value=to_char(plx.contract_id) AND plx.contract_id IS NOT NULL) OR (fad.entity_name=:"SYS_B_163" AND fad.pk1_value=to_char(PO_COMMUNICATION_PVT.getInventoryOrgId()) AND fad.pk2_value=to_char(plx.item_id) AND plx.item_id is not null) ) AND fad.datatype_id=:"SYS_B_164" AND fad.function_name=:"SYS_B_165" order by fad.seq_num) AS line_file_attachments, CURSOR(SELECT pllx.*, CURSOR( SELECT pllx.line_location_id, fds.short_text FROM fnd_attached_docs_form_vl fad, fnd_documents_short_text fds WHERE entity_name = :"SYS_B_166" AND pk1_value = to_char(pllx.line_location_id) AND function_name = :"SYS_B_167" AND fad.media_id = fds.media_id AND fad.datatype_id=:"SYS_B_168" order by fad.seq_num) AS line_loc_short_text, CURSOR( SELECT fad.url web_page --Bug#4958642 FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name=:"SYS_B_169" AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=:"SYS_B_170" AND fad.function_name=:"SYS_B_171" order by fad.seq_num ) AS line_loc_url_attachments, CURSOR( SELECT fad.file_name FROM fnd_attached_docs_form_vl fad WHERE fad.entity_name=:"SYS_B_172" AND fad.pk1_value=to_char(pllx.line_location_id) AND fad.datatype_id=:"SYS_B_173" AND fad.function_name=:"SYS_B_174" order by fad.seq_num) AS line_loc_file_attachments, CURSOR(SELECT pdx.* FROM po_distribution_xml pdx WHERE pdx.po_header_id = phx.po_header_id and pdx.LINE_LOCATION_ID = pllx.LINE_LOCATION_ID) AS distributions FROM po_line_locations_xml pllx WHERE pllx.po_line_id = plx.po_line_id AND NVL(pllx.payment_type, :"SYS_B_175") NOT IN (:"SYS_B_176", :"SYS_B_177") and not exists (select :"SYS_B_178" from po_line_locations_archive_all pllaa where pllaa.line_location_id = pllx.line_location_id and pllaa.cancel_flag=:"SYS_B_179" and pllaa.revision_num < PO_COMMUNICATION_PVT.getRevisionNum()) order by pllx.shipment_num ) AS line_locations FROM po_lines_xml plx WHERE plx.po_header_id = phx.po_header_id and not exists (select :"SYS_B_180" from po_lines_archive_all plaa where plaa.po_line_id = plx.po_line_id and plaa.cancel_flag= :"SYS_B_181" and plaa.revision_num< PO_COMMUNICATION_PVT.getRevisionNum() ) order by plx.line_num) AS lines FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()
ctnvq3qjh4065	begin :1 := por_util_pkg.interface_START_WORKFLOW( :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102); end;
dhfmyks0dra9b	begin CSM_WF_PKG.SR_Post_Upd(:1); end;
f7g96xjhudpzt	BEGIN HXC_TIMECARD.CREATE_TIMECARD (P_VALIDATE => :1 , P_BLOCKS => :2 , P_ATTRIBUTES => :3 , P_DEPOSIT_MODE => :4 , P_TEMPLATE => :5 , P_ITEM_TYPE => :6 , P_APPROVAL_PRC => :7 , P_LOCK_ROWID => :8 , P_TIMECARD_ID => :9 , P_TIMECARD_OVN => :10 , P_MESSAGES => :11 , P_CLA_SAVE => :12 ); END;
faqrbqdzsg47t	SELECT "A2"."ITEM_REVISION" "ITEM_REVISION", "A2"."LINE_NUM" "LINE_NUM", "A2"."ITEM_DESCRIPTION" "ITEM_DESCRIPTION", "A2"."CANCEL_FLAG" "CANCEL_FLAG", "A2"."CANCEL_DATE" "CANCEL_DATE", "A2"."CANCEL_REASON" "CANCEL_REASON", "A2"."VENDOR_PRODUCT_NUM" "VENDOR_PRODUCT_NUM", "A2"."NOTE_TO_VENDOR" "NOTE_TO_VENDOR", "A2"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A2"."UN_NUMBER" "UN_NUMBER", "A2"."UN_DESC" "UN_DESC", "A2"."HAZARD_CLASS" "HAZARD_CLASS", "A2"."ORDER_TYPE_LOOKUP_CODE" "ORDER_TYPE_LOOKUP_CODE", "A2"."CONTRACT_NUM" "CONTRACT_NUM", "A2"."SEGMENT1" "SEGMENT1", "A2"."GLOBAL_AGREEMENT_FLAG" "GLOBAL_AGREEMENT_FLAG", "A2"."QUOTE_VENDOR_QUOTE_NUMBER" "QUOTE_VENDOR_QUOTE_NUMBER", "A2"."QUOTATION_LINE" "QUOTATION_LINE", "A2"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A2"."ATTRIBUTE1" "ATTRIBUTE1", "A2"."ATTRIBUTE2" "ATTRIBUTE2", "A2"."ATTRIBUTE3" "ATTRIBUTE3", "A2"."ATTRIBUTE4" "ATTRIBUTE4", "A2"."ATTRIBUTE5" "ATTRIBUTE5", "A2"."ATTRIBUTE6" "ATTRIBUTE6", "A2"."ATTRIBUTE7" "ATTRIBUTE7", "A2"."ATTRIBUTE8" "ATTRIBUTE8", "A2"."ATTRIBUTE9" "ATTRIBUTE9", "A2"."ATTRIBUTE10" "ATTRIBUTE10", "A2"."ATTRIBUTE11" "ATTRIBUTE11", "A2"."ATTRIBUTE12" "ATTRIBUTE12", "A2"."ATTRIBUTE13" "ATTRIBUTE13", "A2"."ATTRIBUTE14" "ATTRIBUTE14", "A2"."ATTRIBUTE15" "ATTRIBUTE15", "A2"."UNIT_PRICE" "UNIT_PRICE", "A2"."QUANTITY" "QUANTITY", "A2"."QUANTITY_COMMITTED" "QUANTITY_COMMITTED", "A2"."PO_HEADER_ID" "PO_HEADER_ID", "A2"."PO_LINE_ID" "PO_LINE_ID", "A2"."ITEM_ID" "ITEM_ID", "A2"."FROM_HEADER_ID" "FROM_HEADER_ID", "A2"."FROM_LINE_ID" "FROM_LINE_ID", "A2"."REFERENCE_NUM" "REFERENCE_NUM", "A2"."MIN_RELEASE_AMOUNT" "MIN_RELEASE_AMOUNT", "A2"."PRICE_TYPE_LOOKUP_CODE" "PRICE_TYPE_LOOKUP_CODE", "A2"."CLOSED_CODE" "CLOSED_CODE", "A2"."PRICE_BREAK_LOOKUP_CODE" "PRICE_BREAK_LOOKUP_CODE", "A2"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A2"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A2"."REQUEST_ID" "REQUEST_ID", "A2"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A2"."PROGRAM_ID" "PROGRAM_ID", "A2"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A2"."CLOSED_DATE" "CLOSED_DATE", "A2"."CLOSED_REASON" "CLOSED_REASON", "A2"."CLOSED_BY" "CLOSED_BY", "A2"."TRANSACTION_REASON_CODE" "TRANSACTION_REASON_CODE", "A2"."ORG_ID" "ORG_ID", "A2". "HAZARD_CLASS_ID" "HAZARD_CLASS_ID", "A2"."MIN_ORDER_QUANTITY" "MIN_ORDER_QUANTITY", "A2"."MAX_ORDER_QUANTITY" "MAX_ORDER_QUANTITY", "A2"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A2"."OVER_TOLERANCE_ERROR_FLAG" "OVER_TOLERANCE_ERROR_FLAG", "A2"."MARKET_PRICE" "MARKET_PRICE", "A2"."UNORDERED_FLAG" "UNORDERED_FLAG", "A2"."CLOSED_FLAG" "CLOSED_FLAG", "A2"."USER_HOLD_FLAG" "USER_HOLD_FLAG", "A2"."CANCELLED_BY" "CANCELLED_BY", "A2"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A2"."FIRM_DATE" "FIRM_DATE", "A2"."TAXABLE_FLAG" "TAXABLE_FLAG", "A2"."TYPE_1099" "TYPE_1099", "A2"."CAPITAL_EXPENSE_FLAG" "CAPITAL_EXPENSE_FLAG", "A2"."NEGOTIATED_BY_PREPARER_FLAG" "NEGOTIATED_BY_PREPARER_FLAG", "A2"."QC_GRADE" "QC_GRADE", "A2"."BASE_UOM" "BASE_UOM", "A2"."BASE_QTY" "BASE_QTY", "A2"."SECONDARY_UOM" "SECONDARY_UOM", "A2"."SECONDARY_QTY" "SECONDARY_QTY", "A2"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A2"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A2"."LINE_TYPE_ID" "LINE_TYPE_ID", "A2"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A2"."CREATION_DATE" "CREATION_DATE", "A2"."CREATED_BY" "CREATED_BY", "A2"."CATEGORY_ID" "CATEGORY_ID", "A2"."COMMITTED_AMOUNT" "COMMITTED_AMOUNT", "A2"."ALLOW_PRICE_OVERRIDE_FLAG" "ALLOW_PRICE_OVERRIDE_FLAG", "A2"."NOT_TO_EXCEED_PRICE" "NOT_TO_EXCEED_PRICE", "A2"."LIST_PRICE_PER_UNIT" "LIST_PRICE_PER_UNIT", "A2"."UN_NUMBER_ID" "UN_NUMBER_ID", "A2"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A2"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A2"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A2"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A2"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A2"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A2"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A2"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A2"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A2"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A2"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A2"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A2"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A2"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A2"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A2"."GLOBAL_ATTRIBUTE15" "GLOBAL_ATTRIBUTE15", "A2"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A2"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A2"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A2"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A2"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A2 "."LINE_REFERENCE_NUM" "LINE_REFERENCE_NUM", "A2"."PROJECT_ID" "PROJECT_ID", "A2"."TASK_ID" "TASK_ID", "A2"."EXPIRATION_DATE" "EXPIRATION_DATE", "A2"."TAX_CODE_ID" "TAX_CODE_ID", "A2"."OKE_CONTRACT_HEADER_ID" "OKE_CONTRACT_HEADER_ID", "A2"."OKE_CONTRACT_VERSION_ID" "OKE_CONTRACT_VERSION_ID", "A2"."TAX_NAME" "TAX_NAME", "A2"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A2"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A2"."PREFERRED_GRADE" "PREFERRED_GRADE", "A2"."AUCTION_HEADER_ID" "AUCTION_HEADER_ID", "A2"."AUCTION_DISPLAY_NUMBER" "AUCTION_DISPLAY_NUMBER", "A2"."AUCTION_LINE_NUMBER" "AUCTION_LINE_NUMBER", "A2"."BID_NUMBER" "BID_NUMBER", "A2"."BID_LINE_NUMBER" "BID_LINE_NUMBER", "A2"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A2"."SUPPLIER_REF_NUMBER" "SUPPLIER_REF_NUMBER", "A2"."CONTRACT_ID" "CONTRACT_ID", "A2"."JOB_ID" "JOB_ID", "A2"."AMOUNT" "AMOUNT", "A2"."START_DATE" "START_DATE", "A2"."LINE_TYPE" "LINE_TYPE", "A2"."PURCHASE_BASIS" "PURCHASE_BASIS", "A2"."ITEM_NUM" "ITEM_NUM", "A2"."JOB_NAME" "JOB_NAME", "A2"."CONTRACTOR_FIRST_NAME" "CONTRACTOR_FIRST_NAME", "A2"."CONTRACTOR_LAST_NAME" "CONTRACTOR_LAST_NAME", "A2"."LINE_AMOUNT" "LINE_AMOUNT", "A2"."CANCELED_AMOUNT" "CANCELED_AMOUNT", "A2"."TOTAL_LINE_AMOUNT" "TOTAL_LINE_AMOUNT", "A2"."BASE_UNIT_PRICE" "BASE_UNIT_PRICE", "A2"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A2"."MATCHING_BASIS" "MATCHING_BASIS", "A2"."SVC_AMOUNT_NOTIF_SENT" "SVC_AMOUNT_NOTIF_SENT", "A2"."SVC_COMPLETION_NOTIF_SENT" "SVC_COMPLETION_NOTIF_SENT", "A2"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A2"."RETAINAGE_RATE" "RETAINAGE_RATE", "A2"."MAX_RETAINAGE_AMOUNT" "MAX_RETAINAGE_AMOUNT", "A2"."PROGRESS_PAYMENT_RATE" "PROGRESS_PAYMENT_RATE", "A2"."RECOUPMENT_RATE" "RECOUPMENT_RATE", CURSOR (SELECT "A41"."PRICE_TYPE_DSP" "PRICE_TYPE", "A41"."MULTIPLIER" "MULTIPLIER" FROM "PO_PRICE_DIFFERENTIALS_V" "A41" WHERE "A41"."ENTITY_TYPE"='PO LINE' AND "A41"."ENTITY_ID"="A2"."PO_LINE_ID" AND "A41"."ENABLED_FLAG"='Y') "PRICE_DIFF", CURSOR (SELECT "A2"."PO_LINE_ID" "PO_LINE_ID", "A39"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A40", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A39" WHERE ("A40"."ENTITY_NAME"='PO_LINES' AND "A40"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A40"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A40"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORG ID"()) AND "A40"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL OR "A40"."ENTITY_NAME"='PO_HEADERS' AND "A40"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A40"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A40"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A40"."ENTITY_NAME"='PO_HEADERS' AND "A40"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL) AND "A40"."FUNCTION_NAME"='PO_PRINTPO' AND "A40"."MEDIA_ID"="A39"."MEDIA_ID" AND "A40"."DATATYPE_ID"=1 ORDER BY "A40"."SEQ_NUM") "LINE_SHORT_TEXT", CURSOR (SELECT "A38"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A38"."CREATION_DATE" "CREATION_DATE", "A38"."CREATED_BY" "CREATED_BY", "A38"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A38"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A38"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A38"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A38"."PROGRAM_ID" "PROGRAM_ID", "A38"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A38"."REQUEST_ID" "REQUEST_ID", "A38"."PO_HEADER_ID" "PO_HEADER_ID", "A38"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A38"."PO_LINE_ID" "PO_LINE_ID", "A38"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A38"."CONTEXT" "CONTEXT", "A38"."ATTRIBUTE1" "ATTRIBUTE1", "A38"."ATTRIBUTE2" "ATTRIBUTE2", "A38"."ATTRIBUTE3" "ATTRIBUTE3", "A38"."ATTRIBUTE4" "ATTRIBUTE4", "A38"."ATTRIBUTE5" "ATTRIBUTE5", "A38"."ATTRIBUTE6" "ATTRIBUTE6", "A38"."ATTRIBUTE7" "ATTRIBUTE7", "A38"."ATTRIBUTE8" "ATTRIBUTE8", "A38"."ATTRIBUTE9" "ATTRIBUTE9", "A38"."ATTRIBUTE10" "ATTRIBUTE10", "A38"."ATTRIBUTE11" "ATTRIBUTE11", "A38"."ATTRIBUTE12" "ATTRIBUTE12", "A38"."ATTRIBUTE13" "ATTRIBUTE13", "A38"."ATTRIBUTE14" "ATTRIBUTE14", "A38"."ATTRIBUTE15" "ATTRIBUTE15", "A38"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A38"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A38"."LIST_HEADER_ID" "LIST_HEADER_ID", "A38"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A38"."LIST_LINE_ID" "LIST_LINE_ID", "A38"."MODIFIER_DESC" "MODIFIER_DESC", "A38"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A38"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A38"."MODIFIED_FROM" "MODIFIED_FROM", "A38"."MODIFIED_TO" "MODIFIED_TO", "A38"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A38"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A38"."CHANGE_REASON_TEXT" "CHANGE_REASON_T EXT", "A38"."UPDATED_FLAG" "UPDATED_FLAG", "A38"."APPLIED_FLAG" "APPLIED_FLAG", "A38"."OPERAND" "OPERAND", "A38"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A38"."COST_ID" "COST_ID", "A38"."TAX_CODE" "TAX_CODE", "A38"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A38"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A38"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A38"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A38"."INVOICED_FLAG" "INVOICED_FLAG", "A38"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A38"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A38"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A38"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A38"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A38"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A38"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A38"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A38"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A38"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A38"."LIST_LINE_NO" "LIST_LINE_NO", "A38"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A38"."BENEFIT_QTY" "BENEFIT_QTY", "A38"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A38"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A38"."EXPIRATION_DATE" "EXPIRATION_DATE", "A38"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A38"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A38"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A38"."REDEEMED_DATE" "REDEEMED_DATE", "A38"."REDEEMED_FLAG" "REDEEMED_FLAG", "A38"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A38"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A38"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A38"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A38"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A38"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A38"."AC_CONTEXT" "AC_CONTEXT", "A38"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A38"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A38"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A38"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A38"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A38"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A38"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A38"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A38"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A38"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A38"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A38"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A38"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A38"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14" , "A38"."AC_ATTRIBUTE15" "AC_ATTRIBUTE15", "A38"."LOCK_CONTROL" "LOCK_CONTROL", "A38"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A38"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A38"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A38"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A38"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A38"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A38" WHERE "A38"."PO_HEADER_ID"="A2"."PO_HEADER_ID" AND "A38"."PO_LINE_ID"="A2"."PO_LINE_ID" AND "A38"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A38"."PRICING_GROUP_SEQUENCE") "PRICE_MODIFIERS", CURSOR (SELECT "A37"."PRICE_ADJUSTMENT_ID" "PRICE_ADJUSTMENT_ID", "A37"."CREATION_DATE" "CREATION_DATE", "A37"."CREATED_BY" "CREATED_BY", "A37"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A37"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A37"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A37"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A37"."PROGRAM_ID" "PROGRAM_ID", "A37"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A37"."REQUEST_ID" "REQUEST_ID", "A37"."PO_HEADER_ID" "PO_HEADER_ID", "A37"."AUTOMATIC_FLAG" "AUTOMATIC_FLAG", "A37"."PO_LINE_ID" "PO_LINE_ID", "A37"."ADJ_LINE_NUM" "ADJ_LINE_NUM", "A37"."CONTEXT" "CONTEXT", "A37"."ATTRIBUTE1" "ATTRIBUTE1", "A37"."ATTRIBUTE2" "ATTRIBUTE2", "A37"."ATTRIBUTE3" "ATTRIBUTE3", "A37"."ATTRIBUTE4" "ATTRIBUTE4", "A37"."ATTRIBUTE5" "ATTRIBUTE5", "A37"."ATTRIBUTE6" "ATTRIBUTE6", "A37"."ATTRIBUTE7" "ATTRIBUTE7", "A37"."ATTRIBUTE8" "ATTRIBUTE8", "A37"."ATTRIBUTE9" "ATTRIBUTE9", "A37"."ATTRIBUTE10" "ATTRIBUTE10", "A37"."ATTRIBUTE11" "ATTRIBUTE11", "A37"."ATTRIBUTE12" "ATTRIBUTE12", "A37"."ATTRIBUTE13" "ATTRIBUTE13", "A37"."ATTRIBUTE14" "ATTRIBUTE14", "A37"."ATTRIBUTE15" "ATTRIBUTE15", "A37"."ORIG_SYS_DISCOUNT_REF" "ORIG_SYS_DISCOUNT_REF", "A37"."CHANGE_SEQUENCE" "CHANGE_SEQUENCE", "A37"."LIST_HEADER_ID" "LIST_HEADER_ID", "A37"."LIST_TYPE_CODE" "LIST_TYPE_CODE", "A37"."LIST_LINE_ID" "LIST_LINE_ID", "A37"."MODIFIER_DESC" "MODIFIER_DESC", "A37"."LIST_LINE_TYPE_CODE" "LIST_LINE_TYPE_CODE", "A37"."MODIFIER_LINE_TYPE" "MODIFIER_LINE_TYPE", "A37"."MODIFIED_FROM" "MODIFIED_FROM", "A37"."MODIFIED_TO" "MODIFIED_TO", "A37"."UPDATE_ALLOWED" "UPDATE_ALLOWED", "A37"."CHANGE_REASON_CODE" "CHANGE_REASON_CODE", "A37"."CHANGE_REASON_TEXT" "CHANGE_REASON_TEXT", "A37"."UP DATED_FLAG" "UPDATED_FLAG", "A37"."APPLIED_FLAG" "APPLIED_FLAG", "A37"."OPERAND" "OPERAND", "A37"."ARITHMETIC_OPERATOR" "ARITHMETIC_OPERATOR", "A37"."COST_ID" "COST_ID", "A37"."TAX_CODE" "TAX_CODE", "A37"."TAX_EXEMPT_FLAG" "TAX_EXEMPT_FLAG", "A37"."TAX_EXEMPT_NUMBER" "TAX_EXEMPT_NUMBER", "A37"."TAX_EXEMPT_REASON_CODE" "TAX_EXEMPT_REASON_CODE", "A37"."PARENT_ADJUSTMENT_ID" "PARENT_ADJUSTMENT_ID", "A37"."INVOICED_FLAG" "INVOICED_FLAG", "A37"."ESTIMATED_FLAG" "ESTIMATED_FLAG", "A37"."INC_IN_SALES_PERFORMANCE" "INC_IN_SALES_PERFORMANCE", "A37"."ADJUSTED_AMOUNT" "ADJUSTED_AMOUNT", "A37"."PRICING_PHASE_ID" "PRICING_PHASE_ID", "A37"."CHARGE_TYPE_CODE" "CHARGE_TYPE_CODE", "A37"."CHARGE_SUBTYPE_CODE" "CHARGE_SUBTYPE_CODE", "A37"."RANGE_BREAK_QUANTITY" "RANGE_BREAK_QUANTITY", "A37"."ACCRUAL_CONVERSION_RATE" "ACCRUAL_CONVERSION_RATE", "A37"."PRICING_GROUP_SEQUENCE" "PRICING_GROUP_SEQUENCE", "A37"."ACCRUAL_FLAG" "ACCRUAL_FLAG", "A37"."LIST_LINE_NO" "LIST_LINE_NO", "A37"."SOURCE_SYSTEM_CODE" "SOURCE_SYSTEM_CODE", "A37"."BENEFIT_QTY" "BENEFIT_QTY", "A37"."BENEFIT_UOM_CODE" "BENEFIT_UOM_CODE", "A37"."PRINT_ON_INVOICE_FLAG" "PRINT_ON_INVOICE_FLAG", "A37"."EXPIRATION_DATE" "EXPIRATION_DATE", "A37"."REBATE_TRANSACTION_TYPE_CODE" "REBATE_TRANSACTION_TYPE_CODE", "A37"."REBATE_TRANSACTION_REFERENCE" "REBATE_TRANSACTION_REFERENCE", "A37"."REBATE_PAYMENT_SYSTEM_CODE" "REBATE_PAYMENT_SYSTEM_CODE", "A37"."REDEEMED_DATE" "REDEEMED_DATE", "A37"."REDEEMED_FLAG" "REDEEMED_FLAG", "A37"."MODIFIER_LEVEL_CODE" "MODIFIER_LEVEL_CODE", "A37"."PRICE_BREAK_TYPE_CODE" "PRICE_BREAK_TYPE_CODE", "A37"."SUBSTITUTION_ATTRIBUTE" "SUBSTITUTION_ATTRIBUTE", "A37"."PRORATION_TYPE_CODE" "PRORATION_TYPE_CODE", "A37"."INCLUDE_ON_RETURNS_FLAG" "INCLUDE_ON_RETURNS_FLAG", "A37"."CREDIT_OR_CHARGE_FLAG" "CREDIT_OR_CHARGE_FLAG", "A37"."AC_CONTEXT" "AC_CONTEXT", "A37"."AC_ATTRIBUTE1" "AC_ATTRIBUTE1", "A37"."AC_ATTRIBUTE2" "AC_ATTRIBUTE2", "A37"."AC_ATTRIBUTE3" "AC_ATTRIBUTE3", "A37"."AC_ATTRIBUTE4" "AC_ATTRIBUTE4", "A37"."AC_ATTRIBUTE5" "AC_ATTRIBUTE5", "A37"."AC_ATTRIBUTE6" "AC_ATTRIBUTE6", "A37"."AC_ATTRIBUTE7" "AC_ATTRIBUTE7", "A37"."AC_ATTRIBUTE8" "AC_ATTRIBUTE8", "A37"."AC_ATTRIBUTE9" "AC_ATTRIBUTE9", "A37"."AC_ATTRIBUTE10" "AC_ATTRIBUTE10", "A37"."AC_ATTRIBUTE11" "AC_ATTRIBUTE11", "A37"."AC_ATTRIBUTE12" "AC_ATTRIBUTE12", "A37"."AC_ATTRIBUTE13" "AC_ATTRIBUTE13", "A37"."AC_ATTRIBUTE14" "AC_ATTRIBUTE14", "A37"."AC_ATTRIBUT E15" "AC_ATTRIBUTE15", "A37"."LOCK_CONTROL" "LOCK_CONTROL", "A37"."OPERAND_PER_PQTY" "OPERAND_PER_PQTY", "A37"."ADJUSTED_AMOUNT_PER_PQTY" "ADJUSTED_AMOUNT_PER_PQTY", "A37"."INTERCO_INVOICED_FLAG" "INTERCO_INVOICED_FLAG", "A37"."INVOICED_AMOUNT" "INVOICED_AMOUNT", "A37"."RETROBILL_REQUEST_ID" "RETROBILL_REQUEST_ID", "A37"."TAX_RATE_ID" "TAX_RATE_ID" FROM "PO_PRICE_ADJUSTMENTS_XML" "A37" WHERE "A37"."PO_HEADER_ID"="A2"."FROM_HEADER_ID" AND "A37"."PO_LINE_ID"="A2"."FROM_LINE_ID" AND "A37"."PARENT_ADJUSTMENT_ID" IS NULL ORDER BY "A37"."PRICING_GROUP_SEQUENCE") "ADD_PRICE_MODIFIERS", CURSOR (SELECT "A36"."SEGMENT1" "PONUM" FROM "PO"."PO_HEADERS_ALL" "A36" WHERE "A36"."PO_HEADER_ID"="A2"."FROM_HEADER_ID") "ADD_PRICE_PONUM", CURSOR (SELECT "A35"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A35" WHERE ("A35"."ENTITY_NAME"='PO_LINES' AND "A35"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A35"."ENTITY_NAME"='PO_HEADERS' AND "A35"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A35"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A35"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A35"."ENTITY_NAME"='PO_HEADERS' AND "A35"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A35"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A35"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A35"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A35"."DATATYPE_ID"=5 AND "A35"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A35"."SEQ_NUM") "LINE_URL_ATTACHMENTS", CURSOR (SELECT "A34"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A34" WHERE ("A34"."ENTITY_NAME"='PO_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."PO_LINE_ID") OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_HEADER_ID") AND "A2"."FROM_HEADER_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_IN_GA_LINES' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."FROM_LINE_ID") AND "A2"."FROM_LINE_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='PO_HEADERS' AND "A34"."PK1_VALUE"=TO_CHAR("A2"."CONTRACT_ID") AND "A2"."CONTRACT_ID" IS NOT NULL OR "A34"."ENTITY_NAME"='MTL_SYSTEM_ITEMS' AND "A34"."PK1_VALUE"=TO_CHAR("APPS"."PO_COMMUNICATION_PVT"."GETINVENTORYORGID"()) AND "A34"."PK2_VALUE"=TO_CHAR("A2"."ITEM_ID") AND "A2"."ITEM_ID" IS NOT NULL) AND "A34"."DATATYPE_ID"=6 AND "A34"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A34"."SEQ_NUM") "LINE_FILE_ATTACHMENTS", CURSOR (SELECT "A33"."SHIPMENT_NUM" "SHIPMENT_NUM", "A33"."DUE_DATE" "DUE_DATE", "A33"."QUANTITY" "QUANTITY", "A33"."PRICE_OVERRIDE" "PRICE_OVERRIDE", "A33"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A33"."CANCEL_FLAG" "CANCEL_FLAG", "A33"."CANCEL_DATE" "CANCEL_DATE", "A33"."CANCEL_REASON" "CANCEL_REASON", "A33"."TAXABLE_FLAG" "TAXABLE_FLAG", "A33"."START_DATE" "START_DATE", "A33"."END_DATE" "END_DATE", "A33"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A33"."ATTRIBUTE1" "ATTRIBUTE1", "A33"."ATTRIBUTE2" "ATTRIBUTE2", "A33"."ATTRIBUTE3" "ATTRIBUTE3", "A33"."ATTRIBUTE4" "ATTRIBUTE4", "A33"."ATTRIBUTE5" "ATTRIBUTE5", "A33"."ATTRIBUTE6" "ATTRIBUTE6", "A33"."ATTRIBUTE7" "ATTRIBUTE7", "A33"."ATTRIBUTE8" "ATTRIBUTE8", "A33"."ATTRIBUTE9" "ATTRIBUTE9", "A33"."ATTRIBUTE10" "ATTRIBUTE10", "A33"."ATTRIBUTE11" "ATTRIBUTE11", "A33"."ATTRIBUTE12" "ATTRIBUTE12", "A33"."ATTRIBUTE13" "ATTRIBUTE13", "A33"."ATTRIBUTE14" "ATTRIBUTE14", "A33"."ATTRIBUTE15" "ATTRIBUTE15", "A33"."PO_HEADER_ID" "PO_HEADER_ID", "A33"."PO_LINE_ID" "PO_LINE_ID", "A33"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A33"."SHIPMENT_TYPE" "SHIPMENT_TYPE", "A33"."PO_RELEASE_ID" "PO_RELEASE_ID", "A33"."CONSIGNED_FLAG" "CONSIGNED_FLAG", "A33"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A33"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A33"."RECEIVING_ROUTING_ID" "RECEIVING_ROUTING_ID", "A33"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A33"."CLOSED_REASON" "CLOSED_REASON", "A33"."CLOSED_DATE" "CLOSED_DATE", "A33"."CLOSED_BY" "CLOSED_BY", "A33"."ORG_ID" "ORG_ID", "A33"."UNIT_OF_MEASURE_CLASS" "UNIT_OF_MEASURE_CLASS", "A33"."ENCUMBER_NOW" "ENCUMBER_NOW", "A33"."INSPECTION_REQUIRED_FLAG" "INSPECTION_REQUIRED_FLAG", "A33"."RECEIPT_REQUIRED_FLAG" "RECEIPT_REQUIRED_FLAG", "A33"."QTY_RCV_TOLERANCE" "QTY_RCV_TOLERANCE", "A33"."QTY_RCV_EXCEPTION_CODE" "QTY_RCV_EXCEPTION_CODE", "A33"."ENFORCE_SHIP_TO_LOCATION_CODE" "ENFORCE_SHIP_TO_LOCATION_CODE", "A33"."ALLOW_SUBSTITUTE_RECEIPTS_FLAG" "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "A33"."DAYS_EARLY_RECEIPT_ALLOWED" "DAYS_EARLY_RECEIPT_ALLOWED", "A33"."DAYS_LATE_RECEIPT_ALLOWED" "DAYS_LATE_RECEIPT_ALLOWED", "A33"."RECEIPT_DAYS_EXCEPTION_CODE" "RECEIPT_DAYS_EXCEPTION_CODE", "A33"."INVOICE_CLOSE_TOLERANCE" "INVOICE_CLOSE_TOLERANCE", "A33"."RECEIVE_CLOSE_TOLERANCE" "RECEIVE_CLOSE_TOLERANCE", "A33"."SHIP_TO_OR GANIZATION_ID" "SHIP_TO_ORGANIZATION_ID", "A33"."SOURCE_SHIPMENT_ID" "SOURCE_SHIPMENT_ID", "A33"."CLOSED_CODE" "CLOSED_CODE", "A33"."REQUEST_ID" "REQUEST_ID", "A33"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A33"."PROGRAM_ID" "PROGRAM_ID", "A33"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A33"."LAST_ACCEPT_DATE" "LAST_ACCEPT_DATE", "A33"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A33"."ENCUMBERED_DATE" "ENCUMBERED_DATE", "A33"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A33"."FOB_LOOKUP_CODE" "FOB_LOOKUP_CODE", "A33"."FREIGHT_TERMS_LOOKUP_CODE" "FREIGHT_TERMS_LOOKUP_CODE", "A33"."ESTIMATED_TAX_AMOUNT" "ESTIMATED_TAX_AMOUNT", "A33"."FROM_HEADER_ID" "FROM_HEADER_ID", "A33"."FROM_LINE_ID" "FROM_LINE_ID", "A33"."FROM_LINE_LOCATION_ID" "FROM_LINE_LOCATION_ID", "A33"."LEAD_TIME" "LEAD_TIME", "A33"."LEAD_TIME_UNIT" "LEAD_TIME_UNIT", "A33"."PRICE_DISCOUNT" "PRICE_DISCOUNT", "A33"."TERMS_ID" "TERMS_ID", "A33"."APPROVED_FLAG" "APPROVED_FLAG", "A33"."APPROVED_DATE" "APPROVED_DATE", "A33"."CLOSED_FLAG" "CLOSED_FLAG", "A33"."CANCELLED_BY" "CANCELLED_BY", "A33"."FIRM_STATUS_LOOKUP_CODE" "FIRM_STATUS_LOOKUP_CODE", "A33"."FIRM_DATE" "FIRM_DATE", "A33"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A33"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A33"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A33"."CREATION_DATE" "CREATION_DATE", "A33"."CREATED_BY" "CREATED_BY", "A33"."QUANTITY_RECEIVED" "QUANTITY_RECEIVED", "A33"."QUANTITY_ACCEPTED" "QUANTITY_ACCEPTED", "A33"."QUANTITY_REJECTED" "QUANTITY_REJECTED", "A33"."QUANTITY_BILLED" "QUANTITY_BILLED", "A33"."UNIT_MEAS_LOOKUP_CODE" "UNIT_MEAS_LOOKUP_CODE", "A33"."SHIP_VIA_LOOKUP_CODE" "SHIP_VIA_LOOKUP_CODE", "A33"."GLOBAL_ATTRIBUTE_CATEGORY" "GLOBAL_ATTRIBUTE_CATEGORY", "A33"."GLOBAL_ATTRIBUTE1" "GLOBAL_ATTRIBUTE1", "A33"."GLOBAL_ATTRIBUTE2" "GLOBAL_ATTRIBUTE2", "A33"."GLOBAL_ATTRIBUTE3" "GLOBAL_ATTRIBUTE3", "A33"."GLOBAL_ATTRIBUTE4" "GLOBAL_ATTRIBUTE4", "A33"."GLOBAL_ATTRIBUTE5" "GLOBAL_ATTRIBUTE5", "A33"."GLOBAL_ATTRIBUTE6" "GLOBAL_ATTRIBUTE6", "A33"."GLOBAL_ATTRIBUTE7" "GLOBAL_ATTRIBUTE7", "A33"."GLOBAL_ATTRIBUTE8" "GLOBAL_ATTRIBUTE8", "A33"."GLOBAL_ATTRIBUTE9" "GLOBAL_ATTRIBUTE9", "A33"."GLOBAL_ATTRIBUTE10" "GLOBAL_ATTRIBUTE10", "A33"."GLOBAL_ATTRIBUTE11" "GLOBAL_ATTRIBUTE11", "A33"."GLOBAL_ATTRIBUTE12" "GLOBAL_ATTRIBUTE12", "A33"."GLOBAL_ATTRIBUTE13" "GLOBAL_ATTRIBUTE13", "A33"."GLOBAL_ATTRIBUTE14" "GLOBAL_ATTRIBUTE14", "A33"."GLOBAL_ATTRIB UTE15" "GLOBAL_ATTRIBUTE15", "A33"."GLOBAL_ATTRIBUTE16" "GLOBAL_ATTRIBUTE16", "A33"."GLOBAL_ATTRIBUTE17" "GLOBAL_ATTRIBUTE17", "A33"."GLOBAL_ATTRIBUTE18" "GLOBAL_ATTRIBUTE18", "A33"."GLOBAL_ATTRIBUTE19" "GLOBAL_ATTRIBUTE19", "A33"."GLOBAL_ATTRIBUTE20" "GLOBAL_ATTRIBUTE20", "A33"."QUANTITY_SHIPPED" "QUANTITY_SHIPPED", "A33"."COUNTRY_OF_ORIGIN_CODE" "COUNTRY_OF_ORIGIN_CODE", "A33"."TAX_USER_OVERRIDE_FLAG" "TAX_USER_OVERRIDE_FLAG", "A33"."MATCH_OPTION" "MATCH_OPTION", "A33"."TAX_CODE_ID" "TAX_CODE_ID", "A33"."CALCULATE_TAX_FLAG" "CALCULATE_TAX_FLAG", "A33"."CHANGE_PROMISED_DATE_REASON" "CHANGE_PROMISED_DATE_REASON", "A33"."NOTE_TO_RECEIVER" "NOTE_TO_RECEIVER", "A33"."SECONDARY_UNIT_OF_MEASURE" "SECONDARY_UNIT_OF_MEASURE", "A33"."SECONDARY_QUANTITY" "SECONDARY_QUANTITY", "A33"."PREFERRED_GRADE" "PREFERRED_GRADE", "A33"."SECONDARY_QUANTITY_RECEIVED" "SECONDARY_QUANTITY_RECEIVED", "A33"."SECONDARY_QUANTITY_ACCEPTED" "SECONDARY_QUANTITY_ACCEPTED", "A33"."SECONDARY_QUANTITY_REJECTED" "SECONDARY_QUANTITY_REJECTED", "A33"."SECONDARY_QUANTITY_CANCELLED" "SECONDARY_QUANTITY_CANCELLED", "A33"."VMI_FLAG" "VMI_FLAG", "A33"."RETROACTIVE_DATE" "RETROACTIVE_DATE", "A33"."SUPPLIER_ORDER_LINE_NUMBER" "SUPPLIER_ORDER_LINE_NUMBER", "A33"."AMOUNT" "AMOUNT", "A33"."AMOUNT_RECEIVED" "AMOUNT_RECEIVED", "A33"."AMOUNT_BILLED" "AMOUNT_BILLED", "A33"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A33"."AMOUNT_ACCEPTED" "AMOUNT_ACCEPTED", "A33"."AMOUNT_REJECTED" "AMOUNT_REJECTED", "A33"."DROP_SHIP_FLAG" "DROP_SHIP_FLAG", "A33"."SALES_ORDER_UPDATE_DATE" "SALES_ORDER_UPDATE_DATE", "A33"."SHIP_TO_LOCATION_ID" "SHIP_TO_LOCATION_ID", "A33"."SHIP_TO_LOCATION_NAME" "SHIP_TO_LOCATION_NAME", "A33"."SHIP_TO_ADDRESS_LINE1" "SHIP_TO_ADDRESS_LINE1", "A33"."SHIP_TO_ADDRESS_LINE2" "SHIP_TO_ADDRESS_LINE2", "A33"."SHIP_TO_ADDRESS_LINE3" "SHIP_TO_ADDRESS_LINE3", "A33"."SHIP_TO_ADDRESS_LINE4" "SHIP_TO_ADDRESS_LINE4", "A33"."SHIP_TO_ADDRESS_INFO" "SHIP_TO_ADDRESS_INFO", "A33"."SHIP_TO_COUNTRY" "SHIP_TO_COUNTRY", "A33"."IS_SHIPMENT_ONE_TIME_LOC" "IS_SHIPMENT_ONE_TIME_LOC", "A33"."ONE_TIME_ADDRESS_DETAILS" "ONE_TIME_ADDRESS_DETAILS", "A33"."DETAILS" "DETAILS", "A33"."SHIP_CONT_PHONE" "SHIP_CONT_PHONE", "A33"."SHIP_CONT_EMAIL" "SHIP_CONT_EMAIL", "A33"."ULTIMATE_DELIVER_CONT_PHONE" "ULTIMATE_DELIVER_CONT_PHONE", "A33"."ULTIMATE_DELIVER_CONT_EMAIL" "ULTIMATE_DELIVER_CONT_EMAIL", "A33"."SHIP_CONT_NAME" "SHIP_CONT_NAME", "A33"."ULTIMATE_DELIVER_CONT_NAME" "ULTIMATE_DELIVER_CONT_NAME", "A33"."SHIP_CUST_NAME" "SHIP_CUST_NAME", "A33 "."SHIP_CUST_LOCATION" "SHIP_CUST_LOCATION", "A33"."ULTIMATE_DELIVER_CUST_NAME" "ULTIMATE_DELIVER_CUST_NAME", "A33"."ULTIMATE_DELIVER_CUST_LOCATION" "ULTIMATE_DELIVER_CUST_LOCATION", "A33"."SHIP_TO_CONTACT_FAX" "SHIP_TO_CONTACT_FAX", "A33"."ULTIMATE_DELIVER_TO_CONT_NAME" "ULTIMATE_DELIVER_TO_CONT_NAME", "A33"."ULTIMATE_DELIVER_TO_CONT_FAX" "ULTIMATE_DELIVER_TO_CONT_FAX", "A33"."SHIPPING_METHOD" "SHIPPING_METHOD", "A33"."SHIPPING_INSTRUCTIONS" "SHIPPING_INSTRUCTIONS", "A33"."PACKING_INSTRUCTIONS" "PACKING_INSTRUCTIONS", "A33"."CUSTOMER_PRODUCT_DESC" "CUSTOMER_PRODUCT_DESC", "A33"."CUSTOMER_PO_NUM" "CUSTOMER_PO_NUM", "A33"."CUSTOMER_PO_LINE_NUM" "CUSTOMER_PO_LINE_NUM", "A33"."CUSTOMER_PO_SHIPMENT_NUM" "CUSTOMER_PO_SHIPMENT_NUM", "A33"."NEED_BY_DATE" "NEED_BY_DATE", "A33"."PROMISED_DATE" "PROMISED_DATE", "A33"."TOTAL_SHIPMENT_AMOUNT" "TOTAL_SHIPMENT_AMOUNT", "A33"."FINAL_MATCH_FLAG" "FINAL_MATCH_FLAG", "A33"."MANUAL_PRICE_CHANGE_FLAG" "MANUAL_PRICE_CHANGE_FLAG", "A33"."TAX_NAME" "TAX_NAME", "A33"."TRANSACTION_FLOW_HEADER_ID" "TRANSACTION_FLOW_HEADER_ID", "A33"."VALUE_BASIS" "VALUE_BASIS", "A33"."MATCHING_BASIS" "MATCHING_BASIS", "A33"."PAYMENT_TYPE" "PAYMENT_TYPE", "A33"."DESCRIPTION" "DESCRIPTION", "A33"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A33"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A33"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A33"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A33"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A33"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT", "A33"."WORK_APPROVER_ID" "WORK_APPROVER_ID", "A33"."BID_PAYMENT_ID" "BID_PAYMENT_ID", "A33"."AMOUNT_SHIPPED" "AMOUNT_SHIPPED", CURSOR (SELECT "A33"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A91"."SHORT_TEXT" "SHORT_TEXT" FROM "FND_ATTACHED_DOCS_FORM_VL" "A92", "APPLSYS"."FND_DOCUMENTS_SHORT_TEXT" "A91" WHERE "A92"."ENTITY_NAME"='PO_SHIPMENTS' AND "A92"."PK1_VALUE"=TO_CHAR("A33"."LINE_LOCATION_ID") AND "A92"."FUNCTION_NAME"='PO_PRINTPO' AND "A92"."MEDIA_ID"="A91"."MEDIA_ID" AND "A92"."DATATYPE_ID"=1 ORDER BY "A92"."SEQ_NUM") "LINE_LOC_SHORT_TEXT", CURSOR (SELECT "A90"."URL" "WEB_PAGE" FROM "FND_ATTACHED_DOCS_FORM_VL" "A90" WHERE "A90"."ENTITY_NAME"='PO_SHIPMENTS' AND "A90"."PK1_VALUE"=TO_CHAR("A33"."LINE_LOCATION_ID") AND "A90"."DATATYPE_ID"=5 AND "A90"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A90"."SEQ_NUM") "LINE_LOC_URL_ATTACHMENTS", CURSOR (SELECT "A89"."FILE_NAME" "FILE_NAME" FROM "FND_ATTACHED_DOCS_FORM_VL" "A89" WHERE "A89"."ENTITY_NAME"='PO_SHIPM ENTS' AND "A89"."PK1_VALUE"=TO_CHAR("A33"."LINE_LOCATION_ID") AND "A89"."DATATYPE_ID"=6 AND "A89"."FUNCTION_NAME"='PO_PRINTPO' ORDER BY "A89"."SEQ_NUM") "LINE_LOC_FILE_ATTACHMENTS", CURSOR (SELECT "A88"."AMOUNT_ORDERED" "AMOUNT_ORDERED", "A88"."AMOUNT_DELIVERED" "AMOUNT_DELIVERED", "A88"."AMOUNT_CANCELLED" "AMOUNT_CANCELLED", "A88"."DISTRIBUTION_TYPE" "DISTRIBUTION_TYPE", "A88"."AMOUNT_TO_ENCUMBER" "AMOUNT_TO_ENCUMBER", "A88"."INVOICE_ADJUSTMENT_FLAG" "INVOICE_ADJUSTMENT_FLAG", "A88"."DEST_CHARGE_ACCOUNT_ID" "DEST_CHARGE_ACCOUNT_ID", "A88"."DEST_VARIANCE_ACCOUNT_ID" "DEST_VARIANCE_ACCOUNT_ID", "A88"."PROGRAM_UPDATE_DATE" "PROGRAM_UPDATE_DATE", "A88"."PROJECT_ID" "PROJECT_ID", "A88"."TASK_ID" "TASK_ID", "A88"."EXPENDITURE_TYPE" "EXPENDITURE_TYPE", "A88"."PROJECT_ACCOUNTING_CONTEXT" "PROJECT_ACCOUNTING_CONTEXT", "A88"."EXPENDITURE_ORGANIZATION_ID" "EXPENDITURE_ORGANIZATION_ID", "A88"."GL_CLOSED_DATE" "GL_CLOSED_DATE", "A88"."ACCRUE_ON_RECEIPT_FLAG" "ACCRUE_ON_RECEIPT_FLAG", "A88"."EXPENDITURE_ITEM_DATE" "EXPENDITURE_ITEM_DATE", "A88"."ORG_ID" "ORG_ID", "A88"."GL_ENCUMBERED_PERIOD_NAME" "GL_ENCUMBERED_PERIOD_NAME", "A88"."GL_CANCELLED_DATE" "GL_CANCELLED_DATE", "A88"."DESTINATION_TYPE_CODE" "DESTINATION_TYPE_CODE", "A88"."DESTINATION_ORGANIZATION_ID" "DESTINATION_ORGANIZATION_ID", "A88"."DESTINATION_SUBINVENTORY" "DESTINATION_SUBINVENTORY", "A88"."ATTRIBUTE_CATEGORY" "ATTRIBUTE_CATEGORY", "A88"."ATTRIBUTE1" "ATTRIBUTE1", "A88"."ATTRIBUTE2" "ATTRIBUTE2", "A88"."ATTRIBUTE3" "ATTRIBUTE3", "A88"."ATTRIBUTE4" "ATTRIBUTE4", "A88"."ATTRIBUTE5" "ATTRIBUTE5", "A88"."ATTRIBUTE6" "ATTRIBUTE6", "A88"."ATTRIBUTE7" "ATTRIBUTE7", "A88"."ATTRIBUTE8" "ATTRIBUTE8", "A88"."ATTRIBUTE9" "ATTRIBUTE9", "A88"."ATTRIBUTE10" "ATTRIBUTE10", "A88"."ATTRIBUTE11" "ATTRIBUTE11", "A88"."ATTRIBUTE12" "ATTRIBUTE12", "A88"."ATTRIBUTE13" "ATTRIBUTE13", "A88"."ATTRIBUTE14" "ATTRIBUTE14", "A88"."ATTRIBUTE15" "ATTRIBUTE15", "A88"."WIP_ENTITY_ID" "WIP_ENTITY_ID", "A88"."WIP_OPERATION_SEQ_NUM" "WIP_OPERATION_SEQ_NUM", "A88"."WIP_RESOURCE_SEQ_NUM" "WIP_RESOURCE_SEQ_NUM", "A88"."WIP_REPETITIVE_SCHEDULE_ID" "WIP_REPETITIVE_SCHEDULE_ID", "A88"."WIP_LINE_ID" "WIP_LINE_ID", "A88"."BOM_RESOURCE_ID" "BOM_RESOURCE_ID", "A88"."BUDGET_ACCOUNT_ID" "BUDGET_ACCOUNT_ID", "A88"."ACCRUAL_ACCOUNT_ID" "ACCRUAL_ACCOUNT_ID", "A88"."VARIANCE_ACCOUNT_ID" "VARIANCE_ACCOUNT_ID", "A88"."PREVENT_ENCUMBRANCE_FLAG" "PREVENT_ENCUMBRANCE_FLAG", " A88"."USSGL_TRANSACTION_CODE" "USSGL_TRANSACTION_CODE", "A88"."GOVERNMENT_CONTEXT" "GOVERNMENT_CONTEXT", "A88"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTION_ID", "A88"."LAST_UPDATE_DATE" "LAST_UPDATE_DATE", "A88"."LAST_UPDATED_BY" "LAST_UPDATED_BY", "A88"."PO_HEADER_ID" "PO_HEADER_ID", "A88"."PO_LINE_ID" "PO_LINE_ID", "A88"."LINE_LOCATION_ID" "LINE_LOCATION_ID", "A88"."SET_OF_BOOKS_ID" "SET_OF_BOOKS_ID", "A88"."CODE_COMBINATION_ID" "CODE_COMBINATION_ID", "A88"."QUANTITY_ORDERED" "QUANTITY_ORDERED", "A88"."LAST_UPDATE_LOGIN" "LAST_UPDATE_LOGIN", "A88"."CREATION_DATE" "CREATION_DATE", "A88"."CREATED_BY" "CREATED_BY", "A88"."PO_RELEASE_ID" "PO_RELEASE_ID", "A88"."QUANTITY_DELIVERED" "QUANTITY_DELIVERED", "A88"."QUANTITY_BILLED" "QUANTITY_BILLED", "A88"."QUANTITY_CANCELLED" "QUANTITY_CANCELLED", "A88"."REQ_HEADER_REFERENCE_NUM" "REQ_HEADER_REFERENCE_NUM", "A88"."REQ_LINE_REFERENCE_NUM" "REQ_LINE_REFERENCE_NUM", "A88"."REQ_DISTRIBUTION_ID" "REQ_DISTRIBUTION_ID", "A88"."DELIVER_TO_LOCATION_ID" "DELIVER_TO_LOCATION_ID", "A88"."DELIVER_TO_PERSON_ID" "DELIVER_TO_PERSON_ID", "A88"."RATE_DATE" "RATE_DATE", "A88"."RATE" "RATE", "A88"."AMOUNT_BILLED" "AMOUNT_BILLED", "A88"."ACCRUED_FLAG" "ACCRUED_FLAG", "A88"."ENCUMBERED_FLAG" "ENCUMBERED_FLAG", "A88"."ENCUMBERED_AMOUNT" "ENCUMBERED_AMOUNT", "A88"."UNENCUMBERED_QUANTITY" "UNENCUMBERED_QUANTITY", "A88"."UNENCUMBERED_AMOUNT" "UNENCUMBERED_AMOUNT", "A88"."FAILED_FUNDS_LOOKUP_CODE" "FAILED_FUNDS_LOOKUP_CODE", "A88"."GL_ENCUMBERED_DATE" "GL_ENCUMBERED_DATE", "A88"."KANBAN_CARD_ID" "KANBAN_CARD_ID", "A88"."END_ITEM_UNIT_NUMBER" "END_ITEM_UNIT_NUMBER", "A88"."AWARD_ID" "AWARD_ID", "A88"."MRC_RATE_DATE" "MRC_RATE_DATE", "A88"."MRC_RATE" "MRC_RATE", "A88"."MRC_ENCUMBERED_AMOUNT" "MRC_ENCUMBERED_AMOUNT", "A88"."MRC_UNENCUMBERED_AMOUNT" "MRC_UNENCUMBERED_AMOUNT", "A88"."RECOVERABLE_TAX" "RECOVERABLE_TAX", "A88"."NONRECOVERABLE_TAX" "NONRECOVERABLE_TAX", "A88"."RECOVERY_RATE" "RECOVERY_RATE", "A88"."TAX_RECOVERY_OVERRIDE_FLAG" "TAX_RECOVERY_OVERRIDE_FLAG", "A88"."OKE_CONTRACT_LINE_ID" "OKE_CONTRACT_LINE_ID", "A88"."OKE_CONTRACT_DELIVERABLE_ID" "OKE_CONTRACT_DELIVERABLE_ID", "A88"."DESTINATION_CONTEXT" "DESTINATION_CONTEXT", "A88"."DISTRIBUTION_NUM" "DISTRIBUTION_NUM", "A88"."SOURCE_DISTRIBUTION_ID" "SOURCE_DISTRIBUTION_ID", "A88"."REQUEST_ID" "REQUEST_ID", "A88"."PROGRAM_APPLICATION_ID" "PROGRAM_APPLICATION_ID", "A88"."PROGRAM_ID" "PROGRAM_ID", "A88"."CHARGE_ACCOUNT " "CHARGE_ACCOUNT", "A88"."FULL_NAME" "FULL_NAME", "A88"."WORK_TELEPHONE" "WORK_TELEPHONE", "A88"."EMAIL_ADDRESS" "EMAIL_ADDRESS", "A88"."REQUESTER_DELIVER_FIRST_NAME" "REQUESTER_DELIVER_FIRST_NAME", "A88"."REQUESTER_DELIVER_LAST_NAME" "REQUESTER_DELIVER_LAST_NAME", "A88"."REQUESTER_DELIVER_TITLE" "REQUESTER_DELIVER_TITLE", "A88"."QUANTITY_FINANCED" "QUANTITY_FINANCED", "A88"."AMOUNT_FINANCED" "AMOUNT_FINANCED", "A88"."QUANTITY_RECOUPED" "QUANTITY_RECOUPED", "A88"."AMOUNT_RECOUPED" "AMOUNT_RECOUPED", "A88"."RETAINAGE_WITHHELD_AMOUNT" "RETAINAGE_WITHHELD_AMOUNT", "A88"."RETAINAGE_RELEASED_AMOUNT" "RETAINAGE_RELEASED_AMOUNT" FROM "PO_DISTRIBUTION_XML" "A88" WHERE "A88"."PO_HEADER_ID"=:CV1$ AND "A88"."LINE_LOCATION_ID"="A33"."LINE_LOCATION_ID") "DISTRIBUTIONS" FROM "PO_LINE_LOCATIONS_XML" "A33" WHERE "A33"."PO_LINE_ID"="A2"."PO_LINE_ID" AND NVL("A33"."PAYMENT_TYPE", 'NONE')<>'ADVANCE' AND NVL("A33"."PAYMENT_TYPE", 'NONE')<>'DELIVERY' AND NOT EXISTS (SELECT 0 FROM "PO"."PO_LINE_LOCATIONS_ARCHIVE_ALL" "A87" WHERE "A87"."LINE_LOCATION_ID"="A33"."LINE_LOCATION_ID" AND "A87"."CANCEL_FLAG"='Y' AND "A87"."REVISION_NUM"<"APPS"."PO_COMMUNICATION_PVT"."GETREVISIONNUM"()) ORDER BY "A33"."SHIPMENT_NUM") "LINE_LOCATIONS" FROM "PO_LINES_XML" "A2" WHERE "A2"."PO_HEADER_ID"=:CV1$ AND NOT EXISTS (SELECT 0 FROM "PO"."PO_LINES_ARCHIVE_ALL" "A32" WHERE "A32"."PO_LINE_ID"="A2"."PO_LINE_ID" AND "A32"."CANCEL_FLAG"='Y' AND "A32"."REVISION_NUM"<"APPS"."PO_COMMUNICATION_PVT"."GETREVISIONNUM"()) ORDER BY "A2"."LINE_NUM"
gmrwcu0hdcp8b	begin :v1 := CS_SR_CHILD_AUDIT_PKG.CS_SR_Audit_ChildEntities(:v2, :v3); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File