APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 230: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

226: IS
227: SELECT
228: A.register_code
229: FROM
230: JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
231: WHERE
232: a.organization_id = p_organization_id AND
233: a.location_id = p_location_id AND
234: a.register_id = b.register_id AND

Line 1339: JAI_OM_OE_BOND_REG_DTLS b

1335: SELECT
1336: a.register_code
1337: FROM
1338: JAI_OM_OE_BOND_REG_HDRS a,
1339: JAI_OM_OE_BOND_REG_DTLS b
1340: WHERE
1341: A.organization_id = p_organization_id AND
1342: A.location_id = p_location_id AND
1343: A.register_id = b.register_id AND

Line 1385: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

1381: WHERE A.sub_inventory_name = p_subinventory
1382: AND A.organization_id = p_organization_id;
1383: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_order_type_id NUMBER) IS
1384: SELECT A.register_code
1385: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
1386: WHERE A.organization_id = p_organization_id
1387: AND A.location_id = p_location_id
1388: AND A.register_id = b.register_id
1389: AND b.order_flag = 'Y'