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 MTL_INTERORG_PARAMETERS

Line 1061: The intransit_inv_account was picked from mtl_interorg_parameters through cursor

1057: 2. 01/04/2003 Aparajita for bug#2848921
1058: As per the logic above, for internal sales order the first two accounting entries are not
1059: required. But as per this bug, for ISO these two accounting entries should also get passed.
1060:
1061: The intransit_inv_account was picked from mtl_interorg_parameters through cursor
1062: c_get_iso_accounts for the combination of from and to organization. As per the requirement
1063: now, it should be picked from mtl_parameters for the receiving organization. Added cursor
1064: c_get_intransit_inv_account.
1065:

Line 1070: picked up from mtl_interorg_parameters, so using cursor c_get_iso_accounts.

1066: Added the check of fob_point along with in transit type.
1067:
1068: 3. 07/04/2003 Aparajita for bug#2893284
1069: Removed the cursor c_get_intransit_inv_account as the requiremnts are that it should be
1070: picked up from mtl_interorg_parameters, so using cursor c_get_iso_accounts.
1071:
1072: Removed the cursor c_get_intransit_type, as it was redundant and used c_get_iso_accounts.
1073:
1074: 4. 13/05/2003 Nagaraj.s for Bug#2912007

Line 1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

1140: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1141: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1142: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1143: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%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;

Line 1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

1141: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1142: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1143: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%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;

Line 1146: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

1142: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1143: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1144: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1145: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%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;

Line 1182: FROM mtl_interorg_parameters

1178:
1179:
1180: CURSOR c_get_iso_accounts(p_from_org_id NUMBER, p_to_org_id NUMBER) IS
1181: SELECT intransit_type, fob_point, interorg_receivables_account, interorg_payables_account, intransit_inv_account
1182: FROM mtl_interorg_parameters
1183: WHERE from_organization_id = p_from_org_id
1184: AND to_organization_id = p_to_org_id;
1185:
1186: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

Line 1218: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;

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;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

Line 1219: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;

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;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 1220: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

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;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 1221: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

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;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%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;
1222: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1223: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1224: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1225: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1226: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 3512: FROM mtl_interorg_parameters

3508:
3509:
3510: CURSOR c_get_iso_accounts(p_from_org_id NUMBER, p_to_org_id NUMBER) IS
3511: SELECT intransit_type, fob_point, interorg_receivables_account, interorg_payables_account, intransit_inv_account
3512: FROM mtl_interorg_parameters
3513: WHERE from_organization_id = p_from_org_id
3514: AND to_organization_id = p_to_org_id;
3515:
3516: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

Line 3545: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;

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;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

Line 3546: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;

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;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 3547: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

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;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 3548: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

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;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%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;
3549: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3550: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3551: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3552: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3553: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

3562: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3563: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3564: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3565: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%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;

Line 3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

3563: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3564: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3565: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%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;

Line 3568: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

3564: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3565: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3566: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3567: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%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;