eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_RG_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;

1146: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1147: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

Line 1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

1147: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1148: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1149: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1150: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1155: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';

Line 1175: FROM po_requisition_lines_all

1171:
1172: -- get the to organization id from the requisition details
1173: CURSOR c_get_to_organization(p_requisition_header_id NUMBER, p_requisition_line_id NUMBER) IS
1174: SELECT destination_organization_id , deliver_to_location_id /* deliver_to_location_id added by ssumaith - to handle trading to trading ISO */
1175: FROM po_requisition_lines_all
1176: WHERE requisition_header_id = p_requisition_header_id
1177: AND requisition_line_id = p_requisition_line_id;
1178:
1179:

Line 1217: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;

1213: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
1214:
1215:
1216:
1217: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
1218: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
1219: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1220: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1221: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

Line 3505: FROM po_requisition_lines_all

3501:
3502: -- get the to organization id from the requisition details
3503: CURSOR c_get_to_organization(p_requisition_header_id NUMBER, p_requisition_line_id NUMBER) IS
3504: SELECT destination_organization_id , deliver_to_location_id /* deliver_to_location_id added by ssumaith - to handle trading to trading ISO */
3505: FROM po_requisition_lines_all
3506: WHERE requisition_header_id = p_requisition_header_id
3507: AND requisition_line_id = p_requisition_line_id;
3508:
3509:

Line 3544: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;

3540:
3541: /*
3542: The following variables defined for cess trading to trading
3543: */
3544: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
3545: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
3546: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3547: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3548: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

Line 3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;

3568: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3569: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

Line 3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;

3569: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3570: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3571: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3572: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;
3573: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3577: