APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on GL_BC_PACKETS_HISTS

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

1435: -- and gl_bc_packets can be achieved with event id condition
1436: -- This is necessary to improve the performance of the query which will
1437: -- avoid FTS on the XLA table.
1438: --
1439: --Modified the query below to join with gl_bc_packets_hists
1440: --This is so that the error rows are always found. GL moves
1441: --all errored rows to gl_bc_packets_hist for performance reasons.
1442: --
1443: --We have to join with xla_distribution_links to get a mapping between

Line 1530: GL_BC_PACKETS_HISTS GLBCH

1526: PBD.accounted_amt TRANSACTION_AMOUNT,
1527: PBD.reference15 REFERENCE15
1528: FROM XLA_DISTRIBUTION_LINKS XLD,
1529: PO_BC_DISTRIBUTIONS PBD,
1530: GL_BC_PACKETS_HISTS GLBCH
1531: WHERE GLBCH.PACKET_ID IN (SELECT DISTINCT glbch1.packet_id
1532: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1533: GL_BC_PACKETS_HISTS glbch1
1534: WHERE ps_ev_Gt.event_id = glbch1.event_id)

Line 1533: GL_BC_PACKETS_HISTS glbch1

1529: PO_BC_DISTRIBUTIONS PBD,
1530: GL_BC_PACKETS_HISTS GLBCH
1531: WHERE GLBCH.PACKET_ID IN (SELECT DISTINCT glbch1.packet_id
1532: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1533: GL_BC_PACKETS_HISTS glbch1
1534: WHERE ps_ev_Gt.event_id = glbch1.event_id)
1535: AND XLD.AE_HEADER_ID = GLBCH.ae_header_id
1536: AND xld.ae_line_num = GLBCH.ae_line_num
1537: AND xld.event_id = GLBCH.event_id

Line 1618: GL_BC_PACKETS_HISTS GLBCH

1614: * PBD.ACCOUNTED_AMT
1615: TRANSACTION_AMOUNT,
1616: PBD.REFERENCE15 REFERENCE15
1617: FROM PO_BC_DISTRIBUTIONS PBD,
1618: GL_BC_PACKETS_HISTS GLBCH
1619: WHERE pbd.packet_id = p_packet_id
1620: AND pbd.ae_EVENT_ID = GLBCH.EVENT_ID
1621: AND GLBCH.TEMPLATE_ID IS NULL
1622: AND GLBCH.SOURCE_DISTRIBUTION_ID_NUM_1 = pbd.distribution_id --Bug 16437550