[Home] [Help]
37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND
39: apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND
40: poh.segment1 = l_cc_num AND
41: poh.type_lookup_code = 'STANDARD' AND
42: poh.org_id = l_org_id AND
43: pol.po_header_id = poh.po_header_id AND
44: pol.line_num = l_cc_acct_line_num AND
45: pll.po_line_id = pol.po_line_id AND
118: WHERE
119: apid.po_distribution_id = pod.po_distribution_id AND
120: apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND
121: poh.segment1 = l_cc_num AND
122: poh.type_lookup_code = 'STANDARD' AND
123: poh.org_id = l_org_id AND
124: pol.po_header_id = poh.po_header_id AND
125: pol.line_num = l_cc_acct_line_num AND
126: pll.po_line_id = pol.po_line_id AND
196: po_line_locations_all pll,
197: po_distributions_all pod
198: WHERE
199: poh.segment1 = l_cc_num AND
200: poh.type_lookup_code = 'STANDARD' AND
201: poh.org_id = l_org_id AND
202: pol.po_header_id = poh.po_header_id AND
203: pol.line_num = l_cc_acct_line_num AND
204: pll.po_line_id = pol.po_line_id AND
301: po_line_locations_all pll,
302: po_distributions_all pod
303: WHERE
304: poh.segment1 = l_cc_num AND
305: poh.type_lookup_code = 'STANDARD' AND
306: poh.org_id = l_org_id AND
307: pol.po_header_id = poh.po_header_id AND
308: pol.line_num = l_cc_acct_line_num AND
309: pll.po_line_id = pol.po_line_id AND
434: po_headers_all poh
435: WHERE
436: apid.po_distribution_id = pod.po_distribution_id AND
437: poh.segment1 = l_cc_num AND
438: poh.type_lookup_code = 'STANDARD' AND
439: poh.org_id = l_org_id AND
440: pol.po_header_id = poh.po_header_id AND
441: pol.line_num = l_cc_acct_line_num AND
442: pll.po_line_id = pol.po_line_id AND
503: po_headers_all poh
504: WHERE
505: apid.po_distribution_id = pod.po_distribution_id AND
506: poh.segment1 = l_cc_num AND
507: poh.type_lookup_code = 'STANDARD' AND
508: poh.org_id = l_org_id AND
509: pol.po_header_id = poh.po_header_id AND
510: pol.line_num = l_cc_acct_line_num AND
511: pll.po_line_id = pol.po_line_id AND