PO采购-采购订单
来源:互联网 发布:mac下面的图标删掉了 编辑:程序博客网 时间:2024/04/28 07:55
2014-01-06
头信息:
po : po_headers_all.segment1
rev : po_headers_all.revision_num
supplier :
SELECT v.vendor_name
FROM po_headers_all poh,
po_vendors v
where v.vendor_id(+) = poh.vendor_id
and poh.segment1 = 'FCJT1109220015';
ship-to :
SELECT hrl1.location_code
FROM po_headers_all poh,
hr_locations_all_tl hrl1
WHERE hrl1.location_id(+) = poh.ship_to_location_id
AND hrl1.language(+) = userenv('LANG')
AND poh.segment1 = 'FCJT1109220015';
buyer :
SELECT p.full_name
FROM po_headers_all poh,
per_people_f p
WHERE poh.agent_id = p.person_id
AND trunc(SYSDATE) BETWEEN p.effective_start_date AND p.effective_end_date
AND p.employee_number IS NOT NULL
AND poh.segment1 = 'FCJT1109220015';
description : po_headers_all.comments
type :
SELECT pdt.type_name
FROM po_headers_all poh,
po_document_types_all pdt
WHERE ((pdt.document_type_code IN ('PO',
'PA') AND pdt.document_subtype = poh.type_lookup_code))
AND poh.org_id = pdt.org_id
AND poh.segment1 = 'FCJT1109220015';
site :
SELECT vs.vendor_site_code
FROM po_headers_all poh,
po_vendor_sites_all vs
WHERE vs.vendor_site_id(+) = poh.vendor_site_id
AND poh.segment1 = 'FCJT1109220015';
bill-to :
SELECT hrl2.location_code
FROM po_headers_all poh,
hr_locations_all_tl hrl2
WHERE hrl2.location_id(+) = poh.bill_to_location_id
AND hrl2.language(+) = userenv('LANG')
AND poh.segment1 = 'FCJT1109220015';
status : --
created : po_headers_all.creation_date
contact :
SELECT decode(poh.vendor_contact_id,
NULL,
NULL,
vc.last_name || ', ' || vc.first_name)
FROM po_headers_all poh,
po_vendor_contacts vc
WHERE vc.vendor_contact_id(+) = poh.vendor_contact_id
AND poh.segment1 = 'FCJT1109220015';
currency : po_headers_all.currency_code
total : --
行信息:
line tab :
num : po_lines_all.line_num
type :
SELECT plt.line_type
FROM po_lines_all pol,
po_line_types plt
WHERE plt.line_type_id(+) = pol.line_type_id
AND pol.po_header_id = 69774;
item :
SELECT msi.segment1
FROM po_lines_all pol,
mtl_system_items_b msi
WHERE msi.inventory_item_id(+) = pol.item_id
AND msi.organization_id = pol.org_id
AND pol.po_header_id = 69774;
rev : po_lines_all.item_revision
category : --
description :
SELECT msi.description
FROM po_lines_all pol,
mtl_system_items_b msi
WHERE msi.inventory_item_id(+) = pol.item_id
AND msi.organization_id = pol.org_id
AND pol.po_header_id = 69774;
uom : po_lines_all.unit_meas_lookup_code
quantity : po_lines_all.quantity
price : po_lines_all.unit_price
promised date : --
need by date : --
supplier item : po_lines_all.vendor_product_num
price reference tab :
list price : po_lines_all.list_price_per_unit
...
shipments button :
shipments tab :
num :
SELECT pll.shipment_num
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
org :
SELECT mp.organization_code
FROM po_lines_all pol,
po_line_locations_all pll,
mtl_parameters mp
WHERE pol.po_line_id = pll.po_line_id
AND pll.ship_to_organization_id = mp.organization_id
AND pol.po_header_id = 69774;
ship -to :
SELECT hrl.location_code
FROM po_lines_all pol,
po_line_locations_all pll,
hr_locations_all_tl hrl
WHERE pol.po_line_id = pll.po_line_id
AND hrl.location_id(+) = pll.ship_to_location_id
AND hrl.language(+) = userenv('LANG')
AND pol.po_header_id = 69774;
uom :
SELECT decode(pll.shipment_type,
'RFQ',
pll.unit_meas_lookup_code,
'QUOTATION',
pll.unit_meas_lookup_code,
pol.unit_meas_lookup_code)
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
quantity : po_line_locations_all.quantity
promised date : po_line_locations_all.promised_date
need by : po_line_locations_all.need_by_date
original promise : --
note for receiver : po_line_locations_all.note_to_receiver
country of origin : po_line_locations_all.country_of_origin_code
tax code :
SELECT atc.name
FROM po_lines_all pol,
po_line_locations_all pll,
ap_tax_codes atc
WHERE pol.po_line_id = pll.po_line_id
AND pll.tax_code_id = atc.tax_id(+)
AND pol.po_header_id = 69774;
charge account : --
amount : --
more tab :
receipt close tolerance :
SELECT pll.receive_close_tolerance
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
invoice close tolerance :
SELECT pll.invoice_close_tolerance
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
match approval level : --
invoice match option : --
status tab :
status :
SELECT decode(nvl(pll.closed_code,
'OPEN'),
'OPEN',
NULL,
polc1.displayed_field) || decode(pll.cancel_flag,
'Y',
',' || '' || polc2.displayed_field,
NULL)
FROM po_lines_all pol,
po_line_locations_all pll,
po_lookup_codes polc2,
po_lookup_codes polc1
WHERE pol.po_line_id = pll.po_line_id
AND polc2.lookup_type(+) = 'DOCUMENT STATE'
AND polc2.lookup_code(+) = 'CANCELLED'
AND polc1.lookup_type(+) = 'DOCUMENT STATE'
AND polc1.lookup_code(+) = nvl(pll.closed_code,
'OPEN')
AND pol.po_header_id = 69774;
ordered : --
received :
SELECT pll.quantity_received
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
cancelled :
SELECT pll.quantity_cancelled
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
billed :
SELECT pll.quantity_billed
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
receiving controls button :
days early :
SELECT pll.days_early_receipt_allowed
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
days late :
SELECT pll.days_late_receipt_allowed
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
action :
SELECT pll.receipt_days_exception_code
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
last accept date :
SELECT pll.last_accept_date
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
tolerance :
SELECT pll.qty_rcv_tolerance
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
action :
SELECT pll.qty_rcv_exception_code
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
receipt routing :--
enforce ship to :
SELECT pll.enforce_ship_to_location_code
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774;
distirbutions button :
destination tab:
num :
SELECT pod2.distribution_num
FROM po_distributions_all pod2
WHERE pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
type :
SELECT pod2.destination_type_code
FROM po_distributions_all pod2
WHERE pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
requestor :
SELECT ppf.FULL_NAME
FROM po_distributions_all pod2,
per_people_f ppf
WHERE ppf.PERSON_ID = pod2.deliver_to_person_id
and pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
deliver to :
SELECT hla.location_code
FROM po_distributions_all pod2,
hr_locations_all hla
WHERE hla.location_id = pod2.deliver_to_location_id
and pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
subinventory :
SELECT pod2.destination_subinventory
FROM po_distributions_all pod2
WHERE pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
quantity :
SELECT pod2.quantity_ordered
FROM po_distributions_all pod2
WHERE pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
po charge amount :--
destination charege amount : --
recovery rate :
SELECT pod2.recovery_rate
FROM po_distributions_all pod2
WHERE pod2.line_location_id IN (SELECT pll.line_location_id
FROM po_lines_all pol,
po_line_locations_all pll
WHERE pol.po_line_id = pll.po_line_id
AND pol.po_header_id = 69774);
- PO采购-采购订单
- PO 采购订单类型
- EBS --PO采购订单
- ORACLE PO采购订单界面
- PO采购-采购申请单
- MAXIMO 采购配置--采购申请、采购订单
- 查看活动历史记录与PO采购订单的关系
- PO RELEASE 采购订单审核(支持多级审核)
- Oracle EBS:PO 采购订单类型(单据类型)
- PO RELEASE 采购订单审核(支持多级审核)
- PO RELEASE 采购订单审核(支持多级审核)
- Oracle PO 采购订单接口导入 分拆发运行
- SAP 采购订单PO基于采购金额的审批策略配置
- BAPI_PO_CREATE1 批量创建采购订单(可一个PO采购多个材料)
- PO采购-表
- 采购订单批导
- 采购订单收货
- 采购订单历史删除
- 使用BufferedReader的readLine方法读取文件的每一行数据
- linux同步机制之wait_event和wake_up
- 花一天时间预测下未来:Google大牛眼中的2020
- base圖片保存到sqlserver,讀取出來不一樣的問題
- 千亿资本角逐二手车电商,前瞻还是大泡沫?
- PO采购-采购订单
- JDK6和JDK7中的substring()方法
- JSTL fmt:formatNumber 数字、货币格式化
- 《Java优化编程》第五章——JNI程序设计与性能优化
- 正确实现 IDisposable接口,释放托管或非托管资源
- Android多线程任务优化1:探讨AsyncTask的缺陷
- Oracle 表连接方式(内连接/外连接/自连接) 详解
- 多线程和同步01-pthread库
- 當Unity遇上SVN!版本控管的二、三事