APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on GL_BC_PACKETS_HISTS

Line 1355: --Modified the query below to join with gl_bc_packets_hists

1351: END IF;
1352: --
1353: l_progress := '010';
1354: --
1355: --Modified the query below to join with gl_bc_packets_hists
1356: --This is so that the error rows are always found. GL moves
1357: --all errored rows to gl_bc_packets_hist for performance reasons.
1358: --
1359: --We have to join with xla_distribution_links to get a mapping between

Line 1440: GL_BC_PACKETS_HISTS GLBCH

1436: PBD.accounted_amt TRANSACTION_AMOUNT,
1437: PBD.reference15 REFERENCE15
1438: FROM XLA_DISTRIBUTION_LINKS XLD,
1439: PO_BC_DISTRIBUTIONS PBD,
1440: GL_BC_PACKETS_HISTS GLBCH
1441: WHERE GLBCH.PACKET_ID IN (SELECT DISTINCT glbch1.packet_id
1442: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1443: GL_BC_PACKETS_HISTS glbch1
1444: WHERE ps_ev_Gt.event_id = glbch1.event_id)

Line 1443: GL_BC_PACKETS_HISTS glbch1

1439: PO_BC_DISTRIBUTIONS PBD,
1440: GL_BC_PACKETS_HISTS GLBCH
1441: WHERE GLBCH.PACKET_ID IN (SELECT DISTINCT glbch1.packet_id
1442: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1443: GL_BC_PACKETS_HISTS glbch1
1444: WHERE ps_ev_Gt.event_id = glbch1.event_id)
1445: AND XLD.AE_HEADER_ID = GLBCH.ae_header_id
1446: AND xld.ae_line_num = GLBCH.ae_line_num
1447: AND xld.event_id = GLBCH.event_id