DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on OE_ORDER_PUB

Line 14425: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id

14421: BEGIN
14422: SELECT NVL(gsa_indicator, 'N')
14423: INTO l_gsa_indicator_flag
14424: FROM hz_cust_site_uses_all hsu
14425: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id
14426: AND NVL(hsu.org_id,
14427: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL,
14428: SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), - 99)) =
14429: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL,