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.PA_FUNDS_CONTROL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 5390: from po_distributions_all po

5386: or (a.parent_bc_packet_id is not null and b.parent_bc_packet_id is not null)
5387: )
5388: and ((( a.document_type = 'PO' and b.document_type = 'REQ')
5389: and exists ( select 'Y'
5390: from po_distributions_all po
5391: ,po_req_distributions_all req
5392: where req.distribution_id = b.document_distribution_id
5393: and po.po_distribution_id = a.document_distribution_id
5394: and po.req_distribution_id = req.distribution_id

Line 5402: from po_distributions_all po

5398: )
5399: )
5400: OR (( a.document_type = 'AP' and b.document_type = 'PO' )
5401: and exists ( select 'Y'
5402: from po_distributions_all po
5403: ,ap_invoice_distributions_all ap
5404: where po.po_distribution_id = b.document_distribution_id
5405: and ap.invoice_id = a.document_header_id
5406: and ap.distribution_line_number = a.document_distribution_id

Line 5413: from po_distributions_all po

5409: and a.bc_packet_id = p_bc_pkt_id
5410: and b.packet_id = p_packet_id
5411: union /*Bug 13602288: Self Assessed Tax Changes*/
5412: select 'Y'
5413: from po_distributions_all po
5414: ,ap_self_assessed_tax_dist_all ap
5415: where po.po_distribution_id = b.document_distribution_id
5416: and ap.invoice_id = a.document_header_id
5417: and ap.distribution_line_number = a.document_distribution_id

Line 5426: from po_distributions_all po

5422: )
5423: )
5424: OR (( a.document_type = 'AP' and b.document_type in ( 'CC_P_PAY','CC_C_PAY' ))
5425: and exists ( select 'Y'
5426: from po_distributions_all po
5427: ,ap_invoice_distributions_all ap
5428: where po.po_distribution_id = ap.po_distribution_id
5429: and ap.invoice_id = a.document_header_id
5430: and ap.distribution_line_number = a.document_distribution_id

Line 5438: from po_distributions_all po

5434: and a.bc_packet_id = p_bc_pkt_id
5435: and b.packet_id = p_packet_id
5436: union /*Bug 13602288: Self Assessed Tax Changes*/
5437: select 'Y'
5438: from po_distributions_all po
5439: ,ap_self_assessed_tax_dist_all ap
5440: where po.po_distribution_id = ap.po_distribution_id
5441: and ap.invoice_id = a.document_header_id
5442: and ap.distribution_line_number = a.document_distribution_id

Line 11224: pbc.document_type = decode(gl.source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')

11220: and pbc.document_distribution_id = gl.source_distribution_id_num_1
11221: and ((pbc.source_event_id = gl.event_id
11222: and (pbc.document_type = decode(gl.source_distribution_type,'AP_INV_DIST','AP','AP_PREPAY','AP','X')
11223: OR
11224: pbc.document_type = decode(gl.source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')
11225: OR
11226: pbc.document_type = decode(gl.source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')
11227: OR
11228: pbc.document_type = decode(gl.source_distribution_type,'CC','CC_C_PAY')

Line 11259: -- 'PO','PO_DISTRIBUTIONS_ALL',

11255: pb.document_distribution_id
11256: --,decode(pb.document_type,
11257: -- 'AP','AP_INV_DIST',
11258: -- 'AP','PA_AP_BURDEN',
11259: -- 'PO','PO_DISTRIBUTIONS_ALL',
11260: -- 'PO','PA_PO_BURDEN',
11261: -- 'REQ','PA_REQ_BURDEN',
11262: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11263: from pa_bc_packets pb

Line 11271: -- 'PO','PO_DISTRIBUTIONS_ALL',

11267: pb.document_distribution_id
11268: --,decode(pb.document_type,
11269: -- 'AP','AP_INV_DIST',
11270: -- 'AP','PA_AP_BURDEN',
11271: -- 'PO','PO_DISTRIBUTIONS_ALL',
11272: -- 'PO','PA_PO_BURDEN',
11273: -- 'REQ','PA_REQ_BURDEN',
11274: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11275: from pa_bc_packets pb

Line 11517: -- 'PO','PO_DISTRIBUTIONS_ALL',

11513: pb.document_distribution_id
11514: --,decode(pb.document_type,
11515: -- 'AP','AP_INV_DIST',
11516: -- 'AP','PA_AP_BURDEN',
11517: -- 'PO','PO_DISTRIBUTIONS_ALL',
11518: -- 'PO','PA_PO_BURDEN',
11519: -- 'REQ','PA_REQ_BURDEN',
11520: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11521: from pa_bc_packets pb

Line 11529: -- 'PO','PO_DISTRIBUTIONS_ALL',

11525: pb.document_distribution_id
11526: --,decode(pb.document_type,
11527: -- 'AP','AP_INV_DIST',
11528: -- 'AP','PA_AP_BURDEN',
11529: -- 'PO','PO_DISTRIBUTIONS_ALL',
11530: -- 'PO','PA_PO_BURDEN',
11531: -- 'REQ','PA_REQ_BURDEN',
11532: -- 'REQ','PO_REQ_DISTRIBUTIONS_ALL') source_distribution_type
11533: from pa_bc_packets pb

Line 13197: 'PO_DISTRIBUTIONS_ALL','PO',

13193: decode(gl.source_distribution_type,
13194: 'AP_INV_DIST','AP',
13195: 'AP_PREPAY','AP',
13196: 'PA_AP_BURDEN','AP',
13197: 'PO_DISTRIBUTIONS_ALL','PO',
13198: 'PA_PO_BURDEN','PO',
13199: 'PA_REQ_BURDEN','REQ',
13200: 'PO_REQ_DISTRIBUTIONS_ALL','REQ') source_distribution_type
13201: FROM gl_bc_packets gl

Line 14143: OR pb.document_type = decode(l_source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')

14139: /*( pb.source_event_id = l_event_id or pb.bc_event_id = l_event_id
14140: ); */ -- Modified for bug 14665683
14141: /* Removed for bug #14635279 (pb.source_event_id = l_event_id
14142: and (pb.document_type = decode(l_source_distribution_type,'AP_INV_DIST','AP','AP_PREPAY','AP','X')
14143: OR pb.document_type = decode(l_source_distribution_type,'PO_DISTRIBUTIONS_ALL','PO','X')
14144: OR pb.document_type = decode(l_source_distribution_type,'PO_REQ_DISTRIBUTIONS_ALL','REQ','X')
14145: OR pb.document_type = decode(l_source_distribution_type,'CC','CC_C_PAY')
14146: OR pb.document_type = decode(l_source_distribution_type,'CC','CC_P_PAY')
14147: )