DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on STANDARD

Line 366: WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')

362: po_distributions_all pod,
363: gms_award_distributions adl,
364: gl_period_statuses gps,
365: pa_expenditure_types pet
366: WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
367: AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
368: AND POL.PO_LINE_ID = PLL.PO_LINE_ID
369: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED','PLANNED')
370: AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID

Line 369: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED','PLANNED')

365: pa_expenditure_types pet
366: WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
367: AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
368: AND POL.PO_LINE_ID = PLL.PO_LINE_ID
369: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED','PLANNED')
370: AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
371: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID (+)
372: AND PO_INTG_DOCUMENT_FUNDS_GRP.get_active_encumbrance_func /*Bug 6085276 */
373: ('PO', pod.po_DISTRIBUTION_ID) <> 0