SELECT b.org_id,
hou.name operating_unit,
t.NAME,
t.description,
b.line_type,
b.uom_code,
b.gl_id_rev
FROM hr_operating_units hou
,ar_memo_lines_all_tl t
,ar_memo_lines_all_b b
WHERE hou.organization_id = b.org_id
AND b.memo_line_id = t.memo_line_id
AND b.org_id = :p_org_id
hou.name operating_unit,
t.NAME,
t.description,
b.line_type,
b.uom_code,
b.gl_id_rev
FROM hr_operating_units hou
,ar_memo_lines_all_tl t
,ar_memo_lines_all_b b
WHERE hou.organization_id = b.org_id
AND b.memo_line_id = t.memo_line_id
AND b.org_id = :p_org_id
SELECT
ReplyDeletehou.name operating_unit,
a.name,
a.description,
b.line_type AS type,
b.tax_code,
b.tax_product_category,
b.unit_std_price,
b.uom_code,
g.concatenated_segments,
b.invoicing_rule_id,
b.accounting_rule_id,
b.start_date,
b.end_date
FROM
ar.ar_memo_lines_all_tl a,
ar.ar_memo_lines_all_b b,
gl_code_combinations_kfv g,
hr_operating_units hou
WHERE
1 = 1
AND a.org_id = b.org_id
AND a.language = 'US'
AND a.memo_line_id = b.memo_line_id
AND g.code_combination_id (+) = b.gl_id_rev
AND b.org_id = hou.organization_id
It’s very informative and you are obviously very knowledgeable in this area. You have opened my eyes to varying views on this topic with interesting and solid content. Application
ReplyDelete