DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 238: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

234: location_id = p_location_id;
235:
236: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_delivery_detail_id NUMBER, p_order_type_id NUMBER) IS
237: SELECT A.register_code
238: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
239: WHERE A.organization_id = p_organization_id
240: AND A.location_id = p_location_id
241: AND A.register_id = b.register_id
242: AND b.order_flag = 'Y'

Line 329: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

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