DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 233: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

229: location_id = p_location_id;
230:
231: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_delivery_detail_id NUMBER, p_order_type_id NUMBER) IS
232: SELECT A.register_code
233: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
234: WHERE A.organization_id = p_organization_id
235: AND A.location_id = p_location_id
236: AND A.register_id = b.register_id
237: AND b.order_flag = 'Y'

Line 324: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

320: -- Related Cursors added by Arun for Trading on 28 oct 2000 at 3:30
321: CURSOR Trading_register_code_cur(p_organization_id NUMBER, p_location_id NUMBER,
322: p_delivery_detail_id NUMBER, p_order_type_id NUMBER) IS
323: SELECT A.register_code
324: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
325: WHERE A.organization_id = p_organization_id
326: AND A.location_id = p_location_id
327: AND A.register_id = b.register_id
328: AND b.order_flag = 'Y'