DBA Data[Home] [Help]

APPS.QP_PREQ_PUB dependencies on OE_ORDER_PUB

Line 14613: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id

14609: BEGIN
14610: SELECT NVL(gsa_indicator, 'N')
14611: INTO l_gsa_indicator_flag
14612: FROM hz_cust_site_uses_all hsu
14613: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id
14614: AND NVL(hsu.org_id,
14615: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL,
14616: SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), - 99)) =
14617: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL,