APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 252: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

248: IS
249: SELECT
250: A.register_code
251: FROM
252: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
253: WHERE
254: a.organization_id = p_organization_id AND
255: a.location_id = p_location_id AND
256: a.register_id = b.register_id AND

Line 1579: JAI_OM_OE_BOND_REG_DTLS b

1575: SELECT
1576: a.register_code
1577: FROM
1578: JAI_OM_OE_BOND_REG_HDRS a,
1579: JAI_OM_OE_BOND_REG_DTLS b
1580: WHERE
1581: A.organization_id = p_organization_id AND
1582: A.location_id = p_location_id AND
1583: A.register_id = b.register_id AND

Line 1625: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

1621: WHERE A.sub_inventory_name = p_subinventory
1622: AND A.organization_id = p_organization_id;
1623: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_order_type_id NUMBER) IS
1624: SELECT A.register_code
1625: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
1626: WHERE A.organization_id = p_organization_id
1627: AND A.location_id = p_location_id
1628: AND A.register_id = b.register_id
1629: AND b.order_flag = 'Y'