eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_ORDER_SAVE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 14: SELECT flow_status_code,last_update_date FROM oe_order_headers_all WHERE header_id = p_header_id;

10: ,x_last_update_date OUT NOCOPY DATE)
11:
12: IS
13: CURSOR c_gethdrstatus(p_header_id NUMBER) IS
14: SELECT flow_status_code,last_update_date FROM oe_order_headers_all WHERE header_id = p_header_id;
15:
16:
17: l_gethdrstatus c_gethdrstatus%rowtype;
18: lx_order_status VARCHAR2(30) := FND_API.G_MISS_CHAR;

Line 433: select order_type_id from oe_order_headers_all where header_id = c_ordhdr_typeid;

429: CURSOR c_salesrep_info(l_lineid number) IS
430: SELECT salesrep_id from OE_ORDER_LINES_ALL WHERE line_id = l_lineid;
431:
432: CURSOR c_defaulthdrline_rec(c_ordhdr_typeid number) IS
433: select order_type_id from oe_order_headers_all where header_id = c_ordhdr_typeid;
434:
435: CURSOR OrigOrderQtyCur(c_origqtyLineId number) IS
436: select ordered_quantity
437: from oe_order_lines_all

Line 618: SELECT aq.order_header_id FROM ibe_active_quotes aq, oe_order_headers_all oh

614: ,p_party_id IN NUMBER
615: ,x_order_header_id OUT NOCOPY NUMBER)
616: IS
617: CURSOR c_getactive_pendret(custAcctId number,currencyCode varchar2,partyId number) IS
618: SELECT aq.order_header_id FROM ibe_active_quotes aq, oe_order_headers_all oh
619: WHERE aq.party_id = partyId
620: AND aq.cust_account_id = custAcctId
621: AND aq.currency_code = currencyCode
622: AND aq.record_type = 'ORDER'

Line 663: select order_type_id from oe_order_headers_all where header_id = c_ordhdr_id;

659: )
660: IS
661:
662: CURSOR c_defaulthdr_rec(c_ordhdr_id number) IS
663: select order_type_id from oe_order_headers_all where header_id = c_ordhdr_id;
664:
665: l_order_header_id NUMBER := FND_API.G_MISS_NUM;
666: l_ordertype_id NUMBER;
667: l_salesrep_id VARCHAR2(360);

Line 879: select flow_status_code, order_category_code from oe_order_headers_all where header_id = l_hrdId;

875: ,x_order_header_rec OUT NOCOPY OE_Order_PUB.Header_Rec_Type
876: )
877: IS
878: cursor c_get_hdrInfo(l_hrdId Number) is
879: select flow_status_code, order_category_code from oe_order_headers_all where header_id = l_hrdId;
880:
881: l_header_rec c_get_hdrInfo%rowtype;
882: l_flow_status VARCHAR2(30);
883: l_order_category_code VARCHAR2(30);

Line 1155: -- This is the value to be populated in oe_order_headers_all.invoice_to_contact_id.

1151: -- For Header this would be fetched from hz_cust_account_roles.cust_account_role_id.
1152: -- This flow is only for B2B users.
1153: -- A B2B customer can invoice the Order/Invoice to any of the contacts.
1154: -- But for B2C,it is always to him, the customer. No any contact will be present.
1155: -- This is the value to be populated in oe_order_headers_all.invoice_to_contact_id.
1156: -- How this value is retrieved ?
1157: -- This is hz_cust_account_roles.cust_account_role_id whose
1158: -- cust_acct_site_id = hz_cust_acct_sites_all.cust_acct_site_id and
1159: -- hz_cust_acct_sites_all.cust_acct_site_id = hz_cust_site_uses_all.cust_acct_site_id

Line 1259: select ship_to_org_id,invoice_to_org_id from oe_order_headers_all where header_id = cl_hdr_id;

1255: )
1256: IS
1257:
1258: Cursor c_get_hdr_ids(cl_hdr_id number) IS
1259: select ship_to_org_id,invoice_to_org_id from oe_order_headers_all where header_id = cl_hdr_id;
1260:
1261: l_get_hdr_ids c_get_hdr_ids%rowtype;
1262: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
1263: l_shipto_org_id NUMBER;

Line 1635: select created_by from oe_order_headers_all where header_id=l_acc_hdr_id;

1631:
1632: IS
1633:
1634: cursor c_createdby_info(l_acc_hdr_id NUMBER) IS
1635: select created_by from oe_order_headers_all where header_id=l_acc_hdr_id;
1636:
1637: l_env_user_id NUMBER :=FND_GLOBAL.USER_ID;
1638: l_db_user_id NUMBER;
1639:

Line 1845: 'oe_order_headers_all OEH,'||

1841:
1842: l_qty_tmp_query := 'SELECT OEH.order_number,msi.concatenated_segments,msi.DESCRIPTION,'||
1843: 'OEL.line_id,OEL.item_type_code '||
1844: 'FROM oe_order_lines_all OEL,'||
1845: 'oe_order_headers_all OEH,'||
1846: 'mtl_system_items_vl msi '||
1847: 'WHERE OEL.header_id = OEH.header_id '||
1848: 'AND OEL.inventory_item_id = msi.inventory_item_Id '||
1849: 'AND msi.organization_id = oe_profile.value(''OE_ORGANIZATION_ID'', OEL.org_id) '||

Line 2147: 'OE_ORDER_HEADERS_ALL HDR '||

2143: if(p_site_use_type = 'BILL_TO') then
2144: l_addr_validate_qry := 'SELECT HDR.HEADER_ID '||
2145: 'FROM HZ_CUST_SITE_USES SITE, '||
2146: 'HZ_CUST_ACCT_SITES ACCT_SITE, '||
2147: 'OE_ORDER_HEADERS_ALL HDR '||
2148: 'WHERE HDR.HEADER_ID = :invChkHdrId '||
2149: 'AND SITE.SITE_USE_ID = HDR.invoice_to_org_id '||
2150: 'AND SITE.SITE_USE_CODE = ''BILL_TO'' '||
2151: 'AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID '||

Line 2169: 'OE_ORDER_HEADERS_ALL HDR '||

2165: elsif(p_site_use_type = 'SHIP_TO') then
2166: l_addr_validate_qry := 'SELECT HDR.HEADER_ID '||
2167: 'FROM HZ_CUST_SITE_USES SITE, '||
2168: 'HZ_CUST_ACCT_SITES ACCT_SITE, '||
2169: 'OE_ORDER_HEADERS_ALL HDR '||
2170: 'WHERE HDR.HEADER_ID = :shpChkHdrId '||
2171: 'AND SITE.SITE_USE_ID = HDR.ship_to_org_id '||
2172: 'AND SITE.SITE_USE_CODE = ''SHIP_TO'' '||
2173: 'AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID '||

Line 3335: from oe_order_headers_all where header_id=sh_hdr_id;

3331: -- As OE is not sending these, we are populating.
3332: Declare
3333: cursor c_submit_hdrattr(sh_hdr_id number) is
3334: select order_number,last_update_date,flow_status_code
3335: from oe_order_headers_all where header_id=sh_hdr_id;
3336: Begin
3337: open c_submit_hdrattr(x_order_header_id);
3338: fetch c_submit_hdrattr into x_order_number,x_last_update_date,x_flow_status_code;
3339: IF (IBE_UTIL.G_DEBUGON = l_true) THEN